{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "本模块数据全部来自sina财经"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 股票列表 \n",
    "获取沪深上市公司的基本情况。"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>industry</th>\n",
       "      <th>area</th>\n",
       "      <th>pe</th>\n",
       "      <th>outstanding</th>\n",
       "      <th>totals</th>\n",
       "      <th>totalAssets</th>\n",
       "      <th>liquidAssets</th>\n",
       "      <th>fixedAssets</th>\n",
       "      <th>reserved</th>\n",
       "      <th>...</th>\n",
       "      <th>bvps</th>\n",
       "      <th>pb</th>\n",
       "      <th>timeToMarket</th>\n",
       "      <th>undp</th>\n",
       "      <th>perundp</th>\n",
       "      <th>rev</th>\n",
       "      <th>profit</th>\n",
       "      <th>gpr</th>\n",
       "      <th>npr</th>\n",
       "      <th>holders</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>code</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>300785</th>\n",
       "      <td>N值得买</td>\n",
       "      <td>互联网</td>\n",
       "      <td>北京</td>\n",
       "      <td>30.07</td>\n",
       "      <td>0.13</td>\n",
       "      <td>0.53</td>\n",
       "      <td>48764.53</td>\n",
       "      <td>27498.36</td>\n",
       "      <td>19884.82</td>\n",
       "      <td>9259.55</td>\n",
       "      <td>...</td>\n",
       "      <td>8.65</td>\n",
       "      <td>4.73</td>\n",
       "      <td>20190715</td>\n",
       "      <td>19231.93</td>\n",
       "      <td>3.61</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>73.69</td>\n",
       "      <td>17.55</td>\n",
       "      <td>26665.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600078</th>\n",
       "      <td>澄星股份</td>\n",
       "      <td>化工原料</td>\n",
       "      <td>江苏</td>\n",
       "      <td>126.12</td>\n",
       "      <td>6.63</td>\n",
       "      <td>6.63</td>\n",
       "      <td>780936.56</td>\n",
       "      <td>391236.94</td>\n",
       "      <td>249314.55</td>\n",
       "      <td>14515.36</td>\n",
       "      <td>...</td>\n",
       "      <td>2.56</td>\n",
       "      <td>2.44</td>\n",
       "      <td>19970627</td>\n",
       "      <td>74698.28</td>\n",
       "      <td>1.13</td>\n",
       "      <td>17.78</td>\n",
       "      <td>1.56</td>\n",
       "      <td>16.96</td>\n",
       "      <td>1.06</td>\n",
       "      <td>47700.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        name industry area      pe  outstanding  totals  totalAssets  \\\n",
       "code                                                                   \n",
       "300785  N值得买      互联网   北京   30.07         0.13    0.53     48764.53   \n",
       "600078  澄星股份     化工原料   江苏  126.12         6.63    6.63    780936.56   \n",
       "\n",
       "        liquidAssets  fixedAssets  reserved   ...     bvps    pb  \\\n",
       "code                                          ...                  \n",
       "300785      27498.36     19884.82   9259.55   ...     8.65  4.73   \n",
       "600078     391236.94    249314.55  14515.36   ...     2.56  2.44   \n",
       "\n",
       "        timeToMarket      undp  perundp    rev  profit    gpr    npr  holders  \n",
       "code                                                                           \n",
       "300785      20190715  19231.93     3.61   0.00    0.00  73.69  17.55  26665.0  \n",
       "600078      19970627  74698.28     1.13  17.78    1.56  16.96   1.06  47700.0  \n",
       "\n",
       "[2 rows x 22 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import tushare as ts\n",
    "\n",
    "df1 = ts.get_stock_basics()\n",
    "df1.loc[[\"300785\",\"600078\"]]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "返回值说明\n",
    "- code：代码\n",
    "- name：名称\n",
    "- industry：所属行业\n",
    "- area：地区\n",
    "- pe：市盈率\n",
    "- outstanding：流通股本(亿)\n",
    "- totals：总股本（亿）\n",
    "- totalAssets：总资产（亿）\n",
    "- liquidAssets：流动资产（亿）\n",
    "- fixedAssets：固定资产（亿）\n",
    "- reserved：公积金\n",
    "- reservedPerShare：每股公积金\n",
    "- esp：每股收益\n",
    "- bvps：每股净资产\n",
    "- pb：市净率\n",
    "- timeToMarket：上市日期\n",
    "- undp：未分配利润\n",
    "- perundp：每股未分配利润\n",
    "- rev：收入同比增长（%）\n",
    "- profit：利润同比增长\n",
    "- gpr：毛利率（%）\n",
    "- npr：净利润率（%）\n",
    "- holders：股东人数"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 业绩报告（主表）\n",
    "按年度、季度获取业绩报告数据。"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[Getting data:]###############################################"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>name</th>\n",
       "      <th>eps</th>\n",
       "      <th>eps_yoy</th>\n",
       "      <th>bvps</th>\n",
       "      <th>roe</th>\n",
       "      <th>epcf</th>\n",
       "      <th>net_profits</th>\n",
       "      <th>profits_yoy</th>\n",
       "      <th>distrib</th>\n",
       "      <th>report_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>601900</td>\n",
       "      <td>南方传媒</td>\n",
       "      <td>0.51</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.78</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28777.64</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>300499</td>\n",
       "      <td>高澜股份</td>\n",
       "      <td>0.36</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1820.94</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>001979</td>\n",
       "      <td>招商蛇口</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>171909.43</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>603778</td>\n",
       "      <td>乾景园林</td>\n",
       "      <td>0.40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.35</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2381.49</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12-16</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     code  name   eps  eps_yoy  bvps    roe  epcf  net_profits  profits_yoy  \\\n",
       "0  601900  南方传媒  0.51      NaN   NaN  13.78   NaN     28777.64          NaN   \n",
       "1  300499  高澜股份  0.36      NaN   NaN    NaN   NaN      1820.94          NaN   \n",
       "2  001979  招商蛇口   NaN      NaN   NaN    NaN   NaN    171909.43          NaN   \n",
       "3  603778  乾景园林  0.40      NaN   NaN   6.35   NaN      2381.49          NaN   \n",
       "\n",
       "  distrib report_date  \n",
       "0     NaN       01-20  \n",
       "1     NaN       01-20  \n",
       "2     NaN       12-28  \n",
       "3     NaN       12-16  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import tushare as ts\n",
    "\n",
    "# 获取2014年第3季度的业绩报告数据\n",
    "df2 = ts.get_report_data(2014,3)\n",
    "df2.loc[0:3]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "返回值说明：\n",
    "- eps：每股收益\n",
    "- esp_yoy：每股收益同比增长(%)\n",
    "- bvps：每股净资产\n",
    "- roe：每股净资产收益率（%）\n",
    "- epcf：每股现金流量（元）\n",
    "- net_profits：净利润（万元）\n",
    "- profits_yoy：净利润同比增长（%）\n",
    "- distrib：分配方案\n",
    "- report_date：发布日期"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 盈利能力\n",
    "按年度、季度获取盈利能力数据。"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[Getting data:]###############################################"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>name</th>\n",
       "      <th>roe</th>\n",
       "      <th>net_profit_ratio</th>\n",
       "      <th>gross_profit_rate</th>\n",
       "      <th>net_profits</th>\n",
       "      <th>eps</th>\n",
       "      <th>business_income</th>\n",
       "      <th>bips</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>000520</td>\n",
       "      <td>长航凤凰</td>\n",
       "      <td>9404.26</td>\n",
       "      <td>569.35</td>\n",
       "      <td>12.3743</td>\n",
       "      <td>4360.5897</td>\n",
       "      <td>4.3085</td>\n",
       "      <td>765.8858</td>\n",
       "      <td>0.7567</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>600550</td>\n",
       "      <td>保变电气</td>\n",
       "      <td>182.73</td>\n",
       "      <td>9.73</td>\n",
       "      <td>21.5026</td>\n",
       "      <td>292.5635</td>\n",
       "      <td>0.2130</td>\n",
       "      <td>3006.0401</td>\n",
       "      <td>2.1894</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>600816</td>\n",
       "      <td>安信信托</td>\n",
       "      <td>51.47</td>\n",
       "      <td>60.79</td>\n",
       "      <td>81.0632</td>\n",
       "      <td>820.8976</td>\n",
       "      <td>1.8077</td>\n",
       "      <td>1350.2649</td>\n",
       "      <td>2.9734</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>600381</td>\n",
       "      <td>青海春天</td>\n",
       "      <td>48.61</td>\n",
       "      <td>2159.06</td>\n",
       "      <td>-0.9350</td>\n",
       "      <td>154.6058</td>\n",
       "      <td>0.7772</td>\n",
       "      <td>7.1608</td>\n",
       "      <td>0.0359</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>300436</td>\n",
       "      <td>广生堂</td>\n",
       "      <td>47.21</td>\n",
       "      <td>35.41</td>\n",
       "      <td>85.8449</td>\n",
       "      <td>65.3787</td>\n",
       "      <td>NaN</td>\n",
       "      <td>184.5972</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>000420</td>\n",
       "      <td>吉林化纤</td>\n",
       "      <td>46.24</td>\n",
       "      <td>11.85</td>\n",
       "      <td>6.0526</td>\n",
       "      <td>95.4614</td>\n",
       "      <td>0.2523</td>\n",
       "      <td>805.0878</td>\n",
       "      <td>2.1284</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>600385</td>\n",
       "      <td>*ST金泰</td>\n",
       "      <td>37.74</td>\n",
       "      <td>0.89</td>\n",
       "      <td>2.8962</td>\n",
       "      <td>10.7750</td>\n",
       "      <td>0.0727</td>\n",
       "      <td>1203.1931</td>\n",
       "      <td>8.1238</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>000034</td>\n",
       "      <td>神州数码</td>\n",
       "      <td>34.43</td>\n",
       "      <td>14.54</td>\n",
       "      <td>11.5839</td>\n",
       "      <td>54.7170</td>\n",
       "      <td>0.1528</td>\n",
       "      <td>376.2657</td>\n",
       "      <td>1.0510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>002174</td>\n",
       "      <td>游族网络</td>\n",
       "      <td>34.14</td>\n",
       "      <td>44.07</td>\n",
       "      <td>66.4404</td>\n",
       "      <td>254.5113</td>\n",
       "      <td>0.9231</td>\n",
       "      <td>577.4904</td>\n",
       "      <td>2.0945</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>600382</td>\n",
       "      <td>广东明珠</td>\n",
       "      <td>33.38</td>\n",
       "      <td>960.90</td>\n",
       "      <td>64.1516</td>\n",
       "      <td>827.5580</td>\n",
       "      <td>2.4215</td>\n",
       "      <td>86.1226</td>\n",
       "      <td>0.2520</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>600766</td>\n",
       "      <td>园城黄金</td>\n",
       "      <td>32.77</td>\n",
       "      <td>64.56</td>\n",
       "      <td>86.1971</td>\n",
       "      <td>13.0563</td>\n",
       "      <td>0.0582</td>\n",
       "      <td>20.2214</td>\n",
       "      <td>0.0901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>000017</td>\n",
       "      <td>深中华A</td>\n",
       "      <td>32.55</td>\n",
       "      <td>2.09</td>\n",
       "      <td>7.1572</td>\n",
       "      <td>3.3881</td>\n",
       "      <td>0.0061</td>\n",
       "      <td>161.9514</td>\n",
       "      <td>0.2937</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>600340</td>\n",
       "      <td>华夏幸福</td>\n",
       "      <td>30.67</td>\n",
       "      <td>15.73</td>\n",
       "      <td>39.2481</td>\n",
       "      <td>2821.1715</td>\n",
       "      <td>2.1325</td>\n",
       "      <td>17932.2689</td>\n",
       "      <td>13.5554</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>601163</td>\n",
       "      <td>三角轮胎</td>\n",
       "      <td>30.17</td>\n",
       "      <td>11.50</td>\n",
       "      <td>22.7329</td>\n",
       "      <td>784.6137</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6820.3604</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>002180</td>\n",
       "      <td>纳思达</td>\n",
       "      <td>30.00</td>\n",
       "      <td>42.42</td>\n",
       "      <td>61.1285</td>\n",
       "      <td>155.8273</td>\n",
       "      <td>0.3686</td>\n",
       "      <td>367.3036</td>\n",
       "      <td>0.8688</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>000540</td>\n",
       "      <td>中天金融</td>\n",
       "      <td>29.96</td>\n",
       "      <td>15.66</td>\n",
       "      <td>30.4906</td>\n",
       "      <td>1299.0358</td>\n",
       "      <td>1.0089</td>\n",
       "      <td>8294.1839</td>\n",
       "      <td>6.4417</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>002749</td>\n",
       "      <td>国光股份</td>\n",
       "      <td>29.02</td>\n",
       "      <td>23.70</td>\n",
       "      <td>49.8815</td>\n",
       "      <td>118.3064</td>\n",
       "      <td>NaN</td>\n",
       "      <td>498.9830</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>000403</td>\n",
       "      <td>振兴生化</td>\n",
       "      <td>28.53</td>\n",
       "      <td>39.89</td>\n",
       "      <td>57.5425</td>\n",
       "      <td>119.9472</td>\n",
       "      <td>0.4400</td>\n",
       "      <td>300.6756</td>\n",
       "      <td>1.1030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>000848</td>\n",
       "      <td>承德露露</td>\n",
       "      <td>28.25</td>\n",
       "      <td>16.27</td>\n",
       "      <td>41.5106</td>\n",
       "      <td>342.8080</td>\n",
       "      <td>0.6831</td>\n",
       "      <td>2106.7642</td>\n",
       "      <td>4.1981</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>600280</td>\n",
       "      <td>中央商场</td>\n",
       "      <td>27.84</td>\n",
       "      <td>9.63</td>\n",
       "      <td>23.7592</td>\n",
       "      <td>494.4755</td>\n",
       "      <td>0.8612</td>\n",
       "      <td>5133.0713</td>\n",
       "      <td>8.9400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>300432</td>\n",
       "      <td>富临精工</td>\n",
       "      <td>27.33</td>\n",
       "      <td>20.54</td>\n",
       "      <td>34.7766</td>\n",
       "      <td>98.4550</td>\n",
       "      <td>NaN</td>\n",
       "      <td>479.1186</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>000966</td>\n",
       "      <td>长源电力</td>\n",
       "      <td>27.15</td>\n",
       "      <td>12.41</td>\n",
       "      <td>25.0765</td>\n",
       "      <td>621.9214</td>\n",
       "      <td>1.1223</td>\n",
       "      <td>5009.9444</td>\n",
       "      <td>9.0409</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>603898</td>\n",
       "      <td>好莱客</td>\n",
       "      <td>27.12</td>\n",
       "      <td>14.49</td>\n",
       "      <td>37.0830</td>\n",
       "      <td>89.0268</td>\n",
       "      <td>1.2112</td>\n",
       "      <td>614.3379</td>\n",
       "      <td>8.3583</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>300439</td>\n",
       "      <td>美康生物</td>\n",
       "      <td>27.10</td>\n",
       "      <td>23.36</td>\n",
       "      <td>55.9264</td>\n",
       "      <td>102.6853</td>\n",
       "      <td>NaN</td>\n",
       "      <td>439.4746</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>000963</td>\n",
       "      <td>华东医药</td>\n",
       "      <td>26.76</td>\n",
       "      <td>3.86</td>\n",
       "      <td>22.2448</td>\n",
       "      <td>548.5515</td>\n",
       "      <td>1.2637</td>\n",
       "      <td>14180.2914</td>\n",
       "      <td>32.6689</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>300414</td>\n",
       "      <td>中光防雷</td>\n",
       "      <td>26.28</td>\n",
       "      <td>22.90</td>\n",
       "      <td>39.3834</td>\n",
       "      <td>78.5309</td>\n",
       "      <td>NaN</td>\n",
       "      <td>342.9147</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>000957</td>\n",
       "      <td>中通客车</td>\n",
       "      <td>26.17</td>\n",
       "      <td>10.06</td>\n",
       "      <td>15.9001</td>\n",
       "      <td>277.6025</td>\n",
       "      <td>1.1639</td>\n",
       "      <td>2757.3968</td>\n",
       "      <td>11.5611</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>300418</td>\n",
       "      <td>昆仑万维</td>\n",
       "      <td>26.14</td>\n",
       "      <td>17.48</td>\n",
       "      <td>71.6782</td>\n",
       "      <td>252.1020</td>\n",
       "      <td>1.2004</td>\n",
       "      <td>1442.2007</td>\n",
       "      <td>6.8676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>600398</td>\n",
       "      <td>海澜之家</td>\n",
       "      <td>25.68</td>\n",
       "      <td>19.80</td>\n",
       "      <td>39.9099</td>\n",
       "      <td>1612.9821</td>\n",
       "      <td>0.3590</td>\n",
       "      <td>8144.9175</td>\n",
       "      <td>1.8128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>002354</td>\n",
       "      <td>天神娱乐</td>\n",
       "      <td>25.22</td>\n",
       "      <td>41.22</td>\n",
       "      <td>79.5559</td>\n",
       "      <td>141.2720</td>\n",
       "      <td>0.6337</td>\n",
       "      <td>342.6474</td>\n",
       "      <td>1.5370</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2789</th>\n",
       "      <td>600228</td>\n",
       "      <td>ST昌九</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-6.24</td>\n",
       "      <td>7.6811</td>\n",
       "      <td>-32.9108</td>\n",
       "      <td>-0.1363</td>\n",
       "      <td>527.4014</td>\n",
       "      <td>2.1854</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2790</th>\n",
       "      <td>002015</td>\n",
       "      <td>协鑫能科</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-44.59</td>\n",
       "      <td>-35.9454</td>\n",
       "      <td>-448.6780</td>\n",
       "      <td>-1.8699</td>\n",
       "      <td>1006.1826</td>\n",
       "      <td>4.1934</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2791</th>\n",
       "      <td>002741</td>\n",
       "      <td>光华科技</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.28</td>\n",
       "      <td>26.0244</td>\n",
       "      <td>46.3020</td>\n",
       "      <td>0.5144</td>\n",
       "      <td>559.1783</td>\n",
       "      <td>6.2130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2792</th>\n",
       "      <td>002746</td>\n",
       "      <td>仙坛股份</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.57</td>\n",
       "      <td>8.9848</td>\n",
       "      <td>43.8788</td>\n",
       "      <td>0.3671</td>\n",
       "      <td>1228.3704</td>\n",
       "      <td>10.2792</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2793</th>\n",
       "      <td>002755</td>\n",
       "      <td>奥赛康</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.20</td>\n",
       "      <td>23.1990</td>\n",
       "      <td>15.2059</td>\n",
       "      <td>0.2000</td>\n",
       "      <td>292.0243</td>\n",
       "      <td>3.8424</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2794</th>\n",
       "      <td>601900</td>\n",
       "      <td>南方传媒</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.48</td>\n",
       "      <td>29.2215</td>\n",
       "      <td>287.7764</td>\n",
       "      <td>0.4427</td>\n",
       "      <td>3389.6211</td>\n",
       "      <td>5.2148</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2795</th>\n",
       "      <td>600715</td>\n",
       "      <td>文投控股</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-917.01</td>\n",
       "      <td>87.2133</td>\n",
       "      <td>-13.5996</td>\n",
       "      <td>-0.0606</td>\n",
       "      <td>1.4830</td>\n",
       "      <td>0.0066</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2796</th>\n",
       "      <td>002759</td>\n",
       "      <td>天际股份</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.12</td>\n",
       "      <td>32.0775</td>\n",
       "      <td>32.6147</td>\n",
       "      <td>0.4529</td>\n",
       "      <td>268.8833</td>\n",
       "      <td>3.7344</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2797</th>\n",
       "      <td>002763</td>\n",
       "      <td>汇洁股份</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.83</td>\n",
       "      <td>71.8632</td>\n",
       "      <td>130.0017</td>\n",
       "      <td>0.8024</td>\n",
       "      <td>1199.4759</td>\n",
       "      <td>7.4041</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2798</th>\n",
       "      <td>002772</td>\n",
       "      <td>众兴菌业</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21.51</td>\n",
       "      <td>35.6247</td>\n",
       "      <td>55.9740</td>\n",
       "      <td>0.5012</td>\n",
       "      <td>260.1259</td>\n",
       "      <td>2.3292</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2799</th>\n",
       "      <td>002777</td>\n",
       "      <td>久远银海</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.57</td>\n",
       "      <td>44.0504</td>\n",
       "      <td>30.0057</td>\n",
       "      <td>0.5000</td>\n",
       "      <td>221.1071</td>\n",
       "      <td>3.6851</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2800</th>\n",
       "      <td>002786</td>\n",
       "      <td>银宝山新</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.24</td>\n",
       "      <td>17.5528</td>\n",
       "      <td>42.2477</td>\n",
       "      <td>0.4433</td>\n",
       "      <td>1302.0409</td>\n",
       "      <td>13.6625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2801</th>\n",
       "      <td>603023</td>\n",
       "      <td>威帝股份</td>\n",
       "      <td>NaN</td>\n",
       "      <td>45.38</td>\n",
       "      <td>56.2360</td>\n",
       "      <td>65.4757</td>\n",
       "      <td>1.0912</td>\n",
       "      <td>144.2686</td>\n",
       "      <td>2.4044</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2802</th>\n",
       "      <td>603198</td>\n",
       "      <td>迎驾贡酒</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.94</td>\n",
       "      <td>54.0086</td>\n",
       "      <td>345.2102</td>\n",
       "      <td>0.4794</td>\n",
       "      <td>2165.4195</td>\n",
       "      <td>3.0075</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2803</th>\n",
       "      <td>603309</td>\n",
       "      <td>维力医疗</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.23</td>\n",
       "      <td>36.8628</td>\n",
       "      <td>53.9983</td>\n",
       "      <td>0.7199</td>\n",
       "      <td>354.3840</td>\n",
       "      <td>4.7251</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2804</th>\n",
       "      <td>603566</td>\n",
       "      <td>普莱柯</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.41</td>\n",
       "      <td>76.2717</td>\n",
       "      <td>105.2440</td>\n",
       "      <td>0.8770</td>\n",
       "      <td>370.3359</td>\n",
       "      <td>3.0861</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2805</th>\n",
       "      <td>300433</td>\n",
       "      <td>蓝思科技</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.99</td>\n",
       "      <td>24.1976</td>\n",
       "      <td>787.5830</td>\n",
       "      <td>1.2996</td>\n",
       "      <td>9850.1180</td>\n",
       "      <td>16.2543</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2806</th>\n",
       "      <td>300441</td>\n",
       "      <td>鲍斯股份</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17.94</td>\n",
       "      <td>36.1887</td>\n",
       "      <td>34.7829</td>\n",
       "      <td>0.5489</td>\n",
       "      <td>193.8324</td>\n",
       "      <td>3.0592</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2807</th>\n",
       "      <td>603703</td>\n",
       "      <td>盛洋科技</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.34</td>\n",
       "      <td>29.3119</td>\n",
       "      <td>36.6653</td>\n",
       "      <td>0.5323</td>\n",
       "      <td>274.6569</td>\n",
       "      <td>3.9874</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2808</th>\n",
       "      <td>300451</td>\n",
       "      <td>创业慧康</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.59</td>\n",
       "      <td>51.9269</td>\n",
       "      <td>16.3766</td>\n",
       "      <td>0.3211</td>\n",
       "      <td>248.3974</td>\n",
       "      <td>4.8705</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2809</th>\n",
       "      <td>300456</td>\n",
       "      <td>耐威科技</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25.37</td>\n",
       "      <td>41.1566</td>\n",
       "      <td>17.8570</td>\n",
       "      <td>0.2834</td>\n",
       "      <td>70.3787</td>\n",
       "      <td>1.1171</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2810</th>\n",
       "      <td>300460</td>\n",
       "      <td>惠伦晶体</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11.32</td>\n",
       "      <td>25.8515</td>\n",
       "      <td>33.6168</td>\n",
       "      <td>0.2663</td>\n",
       "      <td>296.8572</td>\n",
       "      <td>2.3523</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2811</th>\n",
       "      <td>300468</td>\n",
       "      <td>四方精创</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22.34</td>\n",
       "      <td>50.4209</td>\n",
       "      <td>46.7981</td>\n",
       "      <td>0.6239</td>\n",
       "      <td>209.4103</td>\n",
       "      <td>2.7921</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2812</th>\n",
       "      <td>300472</td>\n",
       "      <td>新元科技</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.74</td>\n",
       "      <td>40.1497</td>\n",
       "      <td>15.7683</td>\n",
       "      <td>0.3153</td>\n",
       "      <td>106.9652</td>\n",
       "      <td>2.1393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2813</th>\n",
       "      <td>603979</td>\n",
       "      <td>金诚信</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.79</td>\n",
       "      <td>26.0682</td>\n",
       "      <td>221.0212</td>\n",
       "      <td>0.7893</td>\n",
       "      <td>2047.6327</td>\n",
       "      <td>7.3129</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2814</th>\n",
       "      <td>300478</td>\n",
       "      <td>杭州高新</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.08</td>\n",
       "      <td>24.4373</td>\n",
       "      <td>34.0657</td>\n",
       "      <td>0.6813</td>\n",
       "      <td>421.1811</td>\n",
       "      <td>8.4236</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2815</th>\n",
       "      <td>300482</td>\n",
       "      <td>万孚生物</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.55</td>\n",
       "      <td>64.4591</td>\n",
       "      <td>77.3260</td>\n",
       "      <td>1.1716</td>\n",
       "      <td>270.8427</td>\n",
       "      <td>4.1036</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2816</th>\n",
       "      <td>300487</td>\n",
       "      <td>蓝晓科技</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19.54</td>\n",
       "      <td>38.5915</td>\n",
       "      <td>37.8129</td>\n",
       "      <td>0.6302</td>\n",
       "      <td>193.4933</td>\n",
       "      <td>3.2248</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2817</th>\n",
       "      <td>300491</td>\n",
       "      <td>通合科技</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24.12</td>\n",
       "      <td>51.2529</td>\n",
       "      <td>23.0985</td>\n",
       "      <td>0.3849</td>\n",
       "      <td>95.7349</td>\n",
       "      <td>1.5955</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2818</th>\n",
       "      <td>300499</td>\n",
       "      <td>高澜股份</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.46</td>\n",
       "      <td>44.0493</td>\n",
       "      <td>18.2094</td>\n",
       "      <td>0.3641</td>\n",
       "      <td>174.0622</td>\n",
       "      <td>3.4812</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2819 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        code   name      roe  net_profit_ratio  gross_profit_rate  \\\n",
       "0     000520   长航凤凰  9404.26            569.35            12.3743   \n",
       "1     600550   保变电气   182.73              9.73            21.5026   \n",
       "2     600816   安信信托    51.47             60.79            81.0632   \n",
       "3     600381   青海春天    48.61           2159.06            -0.9350   \n",
       "4     300436    广生堂    47.21             35.41            85.8449   \n",
       "5     000420   吉林化纤    46.24             11.85             6.0526   \n",
       "6     600385  *ST金泰    37.74              0.89             2.8962   \n",
       "7     000034   神州数码    34.43             14.54            11.5839   \n",
       "8     002174   游族网络    34.14             44.07            66.4404   \n",
       "9     600382   广东明珠    33.38            960.90            64.1516   \n",
       "10    600766   园城黄金    32.77             64.56            86.1971   \n",
       "11    000017   深中华A    32.55              2.09             7.1572   \n",
       "12    600340   华夏幸福    30.67             15.73            39.2481   \n",
       "13    601163   三角轮胎    30.17             11.50            22.7329   \n",
       "14    002180    纳思达    30.00             42.42            61.1285   \n",
       "15    000540   中天金融    29.96             15.66            30.4906   \n",
       "16    002749   国光股份    29.02             23.70            49.8815   \n",
       "17    000403   振兴生化    28.53             39.89            57.5425   \n",
       "18    000848   承德露露    28.25             16.27            41.5106   \n",
       "19    600280   中央商场    27.84              9.63            23.7592   \n",
       "20    300432   富临精工    27.33             20.54            34.7766   \n",
       "21    000966   长源电力    27.15             12.41            25.0765   \n",
       "22    603898    好莱客    27.12             14.49            37.0830   \n",
       "23    300439   美康生物    27.10             23.36            55.9264   \n",
       "24    000963   华东医药    26.76              3.86            22.2448   \n",
       "25    300414   中光防雷    26.28             22.90            39.3834   \n",
       "26    000957   中通客车    26.17             10.06            15.9001   \n",
       "27    300418   昆仑万维    26.14             17.48            71.6782   \n",
       "28    600398   海澜之家    25.68             19.80            39.9099   \n",
       "29    002354   天神娱乐    25.22             41.22            79.5559   \n",
       "...      ...    ...      ...               ...                ...   \n",
       "2789  600228   ST昌九      NaN             -6.24             7.6811   \n",
       "2790  002015   协鑫能科      NaN            -44.59           -35.9454   \n",
       "2791  002741   光华科技      NaN              8.28            26.0244   \n",
       "2792  002746   仙坛股份      NaN              3.57             8.9848   \n",
       "2793  002755    奥赛康      NaN              5.20            23.1990   \n",
       "2794  601900   南方传媒      NaN              8.48            29.2215   \n",
       "2795  600715   文投控股      NaN           -917.01            87.2133   \n",
       "2796  002759   天际股份      NaN             12.12            32.0775   \n",
       "2797  002763   汇洁股份      NaN             10.83            71.8632   \n",
       "2798  002772   众兴菌业      NaN             21.51            35.6247   \n",
       "2799  002777   久远银海      NaN             13.57            44.0504   \n",
       "2800  002786   银宝山新      NaN              3.24            17.5528   \n",
       "2801  603023   威帝股份      NaN             45.38            56.2360   \n",
       "2802  603198   迎驾贡酒      NaN             15.94            54.0086   \n",
       "2803  603309   维力医疗      NaN             15.23            36.8628   \n",
       "2804  603566    普莱柯      NaN             28.41            76.2717   \n",
       "2805  300433   蓝思科技      NaN              7.99            24.1976   \n",
       "2806  300441   鲍斯股份      NaN             17.94            36.1887   \n",
       "2807  603703   盛洋科技      NaN             13.34            29.3119   \n",
       "2808  300451   创业慧康      NaN              6.59            51.9269   \n",
       "2809  300456   耐威科技      NaN             25.37            41.1566   \n",
       "2810  300460   惠伦晶体      NaN             11.32            25.8515   \n",
       "2811  300468   四方精创      NaN             22.34            50.4209   \n",
       "2812  300472   新元科技      NaN             14.74            40.1497   \n",
       "2813  603979    金诚信      NaN             10.79            26.0682   \n",
       "2814  300478   杭州高新      NaN              8.08            24.4373   \n",
       "2815  300482   万孚生物      NaN             28.55            64.4591   \n",
       "2816  300487   蓝晓科技      NaN             19.54            38.5915   \n",
       "2817  300491   通合科技      NaN             24.12            51.2529   \n",
       "2818  300499   高澜股份      NaN             10.46            44.0493   \n",
       "\n",
       "      net_profits     eps  business_income     bips  \n",
       "0       4360.5897  4.3085         765.8858   0.7567  \n",
       "1        292.5635  0.2130        3006.0401   2.1894  \n",
       "2        820.8976  1.8077        1350.2649   2.9734  \n",
       "3        154.6058  0.7772           7.1608   0.0359  \n",
       "4         65.3787     NaN         184.5972      NaN  \n",
       "5         95.4614  0.2523         805.0878   2.1284  \n",
       "6         10.7750  0.0727        1203.1931   8.1238  \n",
       "7         54.7170  0.1528         376.2657   1.0510  \n",
       "8        254.5113  0.9231         577.4904   2.0945  \n",
       "9        827.5580  2.4215          86.1226   0.2520  \n",
       "10        13.0563  0.0582          20.2214   0.0901  \n",
       "11         3.3881  0.0061         161.9514   0.2937  \n",
       "12      2821.1715  2.1325       17932.2689  13.5554  \n",
       "13       784.6137     NaN        6820.3604      NaN  \n",
       "14       155.8273  0.3686         367.3036   0.8688  \n",
       "15      1299.0358  1.0089        8294.1839   6.4417  \n",
       "16       118.3064     NaN         498.9830      NaN  \n",
       "17       119.9472  0.4400         300.6756   1.1030  \n",
       "18       342.8080  0.6831        2106.7642   4.1981  \n",
       "19       494.4755  0.8612        5133.0713   8.9400  \n",
       "20        98.4550     NaN         479.1186      NaN  \n",
       "21       621.9214  1.1223        5009.9444   9.0409  \n",
       "22        89.0268  1.2112         614.3379   8.3583  \n",
       "23       102.6853     NaN         439.4746      NaN  \n",
       "24       548.5515  1.2637       14180.2914  32.6689  \n",
       "25        78.5309     NaN         342.9147      NaN  \n",
       "26       277.6025  1.1639        2757.3968  11.5611  \n",
       "27       252.1020  1.2004        1442.2007   6.8676  \n",
       "28      1612.9821  0.3590        8144.9175   1.8128  \n",
       "29       141.2720  0.6337         342.6474   1.5370  \n",
       "...           ...     ...              ...      ...  \n",
       "2789     -32.9108 -0.1363         527.4014   2.1854  \n",
       "2790    -448.6780 -1.8699        1006.1826   4.1934  \n",
       "2791      46.3020  0.5144         559.1783   6.2130  \n",
       "2792      43.8788  0.3671        1228.3704  10.2792  \n",
       "2793      15.2059  0.2000         292.0243   3.8424  \n",
       "2794     287.7764  0.4427        3389.6211   5.2148  \n",
       "2795     -13.5996 -0.0606           1.4830   0.0066  \n",
       "2796      32.6147  0.4529         268.8833   3.7344  \n",
       "2797     130.0017  0.8024        1199.4759   7.4041  \n",
       "2798      55.9740  0.5012         260.1259   2.3292  \n",
       "2799      30.0057  0.5000         221.1071   3.6851  \n",
       "2800      42.2477  0.4433        1302.0409  13.6625  \n",
       "2801      65.4757  1.0912         144.2686   2.4044  \n",
       "2802     345.2102  0.4794        2165.4195   3.0075  \n",
       "2803      53.9983  0.7199         354.3840   4.7251  \n",
       "2804     105.2440  0.8770         370.3359   3.0861  \n",
       "2805     787.5830  1.2996        9850.1180  16.2543  \n",
       "2806      34.7829  0.5489         193.8324   3.0592  \n",
       "2807      36.6653  0.5323         274.6569   3.9874  \n",
       "2808      16.3766  0.3211         248.3974   4.8705  \n",
       "2809      17.8570  0.2834          70.3787   1.1171  \n",
       "2810      33.6168  0.2663         296.8572   2.3523  \n",
       "2811      46.7981  0.6239         209.4103   2.7921  \n",
       "2812      15.7683  0.3153         106.9652   2.1393  \n",
       "2813     221.0212  0.7893        2047.6327   7.3129  \n",
       "2814      34.0657  0.6813         421.1811   8.4236  \n",
       "2815      77.3260  1.1716         270.8427   4.1036  \n",
       "2816      37.8129  0.6302         193.4933   3.2248  \n",
       "2817      23.0985  0.3849          95.7349   1.5955  \n",
       "2818      18.2094  0.3641         174.0622   3.4812  \n",
       "\n",
       "[2819 rows x 9 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import tushare as ts\n",
    "\n",
    "# 获取2014年第3季度的盈利能力数据\n",
    "df3 = ts.get_profit_data(2014,3)\n",
    "df3.loc[0:3]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "返回值说明：\n",
    "- roe：净资产收益率（%）\n",
    "- net_profit_ratio：净利率（%）\n",
    "- gross_profit_rate：毛利率（%）\n",
    "- net_profits：净利润（万元）\n",
    "- eps：每股收益\n",
    "- business_income：营业收入（百万元）\n",
    "- bips：每股主营业务收入（元）"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 营运能力\n",
    "按年度、季度获取盈运能力数据。"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[Getting data:]################################################"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>name</th>\n",
       "      <th>arturnover</th>\n",
       "      <th>arturndays</th>\n",
       "      <th>inventory_turnover</th>\n",
       "      <th>inventory_days</th>\n",
       "      <th>currentasset_turnover</th>\n",
       "      <th>currentasset_days</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>600605</td>\n",
       "      <td>汇通能源</td>\n",
       "      <td>5.7747</td>\n",
       "      <td>46.7557</td>\n",
       "      <td>102298.4414</td>\n",
       "      <td>0.0026</td>\n",
       "      <td>3.9518</td>\n",
       "      <td>68.3233</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>002649</td>\n",
       "      <td>博彦科技</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>90.0000</td>\n",
       "      <td>37127.2743</td>\n",
       "      <td>0.0073</td>\n",
       "      <td>1.0532</td>\n",
       "      <td>256.3616</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>002707</td>\n",
       "      <td>众信旅游</td>\n",
       "      <td>20.0313</td>\n",
       "      <td>13.4789</td>\n",
       "      <td>7704.9730</td>\n",
       "      <td>0.0350</td>\n",
       "      <td>3.7006</td>\n",
       "      <td>72.9611</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>002039</td>\n",
       "      <td>黔源电力</td>\n",
       "      <td>7.8636</td>\n",
       "      <td>34.3354</td>\n",
       "      <td>6360.2514</td>\n",
       "      <td>0.0425</td>\n",
       "      <td>2.0979</td>\n",
       "      <td>128.7001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>300071</td>\n",
       "      <td>华谊嘉信</td>\n",
       "      <td>1.8090</td>\n",
       "      <td>149.2537</td>\n",
       "      <td>3002.9073</td>\n",
       "      <td>0.0899</td>\n",
       "      <td>1.4096</td>\n",
       "      <td>191.5437</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>002357</td>\n",
       "      <td>富临运业</td>\n",
       "      <td>53.2925</td>\n",
       "      <td>5.0664</td>\n",
       "      <td>2947.0547</td>\n",
       "      <td>0.0916</td>\n",
       "      <td>0.5839</td>\n",
       "      <td>462.4079</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>002400</td>\n",
       "      <td>省广集团</td>\n",
       "      <td>4.7772</td>\n",
       "      <td>56.5185</td>\n",
       "      <td>2592.9770</td>\n",
       "      <td>0.1041</td>\n",
       "      <td>1.5046</td>\n",
       "      <td>179.4497</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>000415</td>\n",
       "      <td>渤海租赁</td>\n",
       "      <td>8.1159</td>\n",
       "      <td>33.2680</td>\n",
       "      <td>1608.9875</td>\n",
       "      <td>0.1678</td>\n",
       "      <td>0.4496</td>\n",
       "      <td>600.5338</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>603056</td>\n",
       "      <td>德邦股份</td>\n",
       "      <td>30.3940</td>\n",
       "      <td>8.8833</td>\n",
       "      <td>1217.1230</td>\n",
       "      <td>0.2218</td>\n",
       "      <td>5.7985</td>\n",
       "      <td>46.5638</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>600897</td>\n",
       "      <td>厦门空港</td>\n",
       "      <td>5.1100</td>\n",
       "      <td>52.8376</td>\n",
       "      <td>1093.2727</td>\n",
       "      <td>0.2470</td>\n",
       "      <td>0.6361</td>\n",
       "      <td>424.4616</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>002238</td>\n",
       "      <td>天威视讯</td>\n",
       "      <td>15.5591</td>\n",
       "      <td>17.3532</td>\n",
       "      <td>903.7139</td>\n",
       "      <td>0.2988</td>\n",
       "      <td>0.8321</td>\n",
       "      <td>324.4802</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>000068</td>\n",
       "      <td>华控赛格</td>\n",
       "      <td>0.1597</td>\n",
       "      <td>1690.6700</td>\n",
       "      <td>731.1300</td>\n",
       "      <td>0.3693</td>\n",
       "      <td>0.1143</td>\n",
       "      <td>2362.2047</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>300347</td>\n",
       "      <td>泰格医药</td>\n",
       "      <td>2.2217</td>\n",
       "      <td>121.5286</td>\n",
       "      <td>728.8232</td>\n",
       "      <td>0.3705</td>\n",
       "      <td>0.5963</td>\n",
       "      <td>452.7922</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>000089</td>\n",
       "      <td>深圳机场</td>\n",
       "      <td>4.9080</td>\n",
       "      <td>55.0122</td>\n",
       "      <td>516.1776</td>\n",
       "      <td>0.5231</td>\n",
       "      <td>1.1366</td>\n",
       "      <td>237.5506</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>600452</td>\n",
       "      <td>涪陵电力</td>\n",
       "      <td>733.7627</td>\n",
       "      <td>0.3680</td>\n",
       "      <td>503.8469</td>\n",
       "      <td>0.5359</td>\n",
       "      <td>8.5228</td>\n",
       "      <td>31.6797</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>002210</td>\n",
       "      <td>*ST飞马</td>\n",
       "      <td>24.1954</td>\n",
       "      <td>11.1591</td>\n",
       "      <td>496.0065</td>\n",
       "      <td>0.5443</td>\n",
       "      <td>1.4342</td>\n",
       "      <td>188.2583</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>300170</td>\n",
       "      <td>汉得信息</td>\n",
       "      <td>1.6666</td>\n",
       "      <td>162.0065</td>\n",
       "      <td>390.7866</td>\n",
       "      <td>0.6909</td>\n",
       "      <td>0.5860</td>\n",
       "      <td>460.7509</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>600995</td>\n",
       "      <td>文山电力</td>\n",
       "      <td>33.6387</td>\n",
       "      <td>8.0265</td>\n",
       "      <td>385.9168</td>\n",
       "      <td>0.6996</td>\n",
       "      <td>4.0343</td>\n",
       "      <td>66.9261</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>601519</td>\n",
       "      <td>大智慧</td>\n",
       "      <td>7.9374</td>\n",
       "      <td>34.0162</td>\n",
       "      <td>367.4597</td>\n",
       "      <td>0.7348</td>\n",
       "      <td>0.2734</td>\n",
       "      <td>987.5640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>600221</td>\n",
       "      <td>海航控股</td>\n",
       "      <td>45.5567</td>\n",
       "      <td>5.9267</td>\n",
       "      <td>323.0456</td>\n",
       "      <td>0.8358</td>\n",
       "      <td>0.9988</td>\n",
       "      <td>270.3244</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>000061</td>\n",
       "      <td>农产品</td>\n",
       "      <td>21.5687</td>\n",
       "      <td>12.5181</td>\n",
       "      <td>297.1456</td>\n",
       "      <td>0.9086</td>\n",
       "      <td>0.4582</td>\n",
       "      <td>589.2623</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>600131</td>\n",
       "      <td>岷江水电</td>\n",
       "      <td>379.1344</td>\n",
       "      <td>0.7121</td>\n",
       "      <td>263.3637</td>\n",
       "      <td>1.0252</td>\n",
       "      <td>2.5380</td>\n",
       "      <td>106.3830</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>601598</td>\n",
       "      <td>中国外运</td>\n",
       "      <td>4.6638</td>\n",
       "      <td>57.8927</td>\n",
       "      <td>259.0900</td>\n",
       "      <td>1.0421</td>\n",
       "      <td>2.0358</td>\n",
       "      <td>132.6260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>000791</td>\n",
       "      <td>甘肃电投</td>\n",
       "      <td>6.8075</td>\n",
       "      <td>39.6621</td>\n",
       "      <td>229.9359</td>\n",
       "      <td>1.1742</td>\n",
       "      <td>1.5252</td>\n",
       "      <td>177.0260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>300383</td>\n",
       "      <td>光环新网</td>\n",
       "      <td>7.6201</td>\n",
       "      <td>35.4326</td>\n",
       "      <td>213.4395</td>\n",
       "      <td>1.2650</td>\n",
       "      <td>1.2123</td>\n",
       "      <td>222.7171</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>601518</td>\n",
       "      <td>吉林高速</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>197.4238</td>\n",
       "      <td>1.3676</td>\n",
       "      <td>0.5841</td>\n",
       "      <td>462.2496</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>600505</td>\n",
       "      <td>西昌电力</td>\n",
       "      <td>10.2375</td>\n",
       "      <td>26.3736</td>\n",
       "      <td>179.0883</td>\n",
       "      <td>1.5076</td>\n",
       "      <td>2.0458</td>\n",
       "      <td>131.9777</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>600012</td>\n",
       "      <td>皖通高速</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>176.4436</td>\n",
       "      <td>1.5302</td>\n",
       "      <td>1.0015</td>\n",
       "      <td>269.5956</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>600652</td>\n",
       "      <td>*ST游久</td>\n",
       "      <td>8.3670</td>\n",
       "      <td>32.2696</td>\n",
       "      <td>173.3283</td>\n",
       "      <td>1.5577</td>\n",
       "      <td>1.6628</td>\n",
       "      <td>162.3767</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>300052</td>\n",
       "      <td>中青宝</td>\n",
       "      <td>2.8077</td>\n",
       "      <td>96.1641</td>\n",
       "      <td>168.3620</td>\n",
       "      <td>1.6037</td>\n",
       "      <td>0.6731</td>\n",
       "      <td>401.1291</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2792</th>\n",
       "      <td>603901</td>\n",
       "      <td>永创智能</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2793</th>\n",
       "      <td>300468</td>\n",
       "      <td>四方精创</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2794</th>\n",
       "      <td>603968</td>\n",
       "      <td>醋化股份</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2795</th>\n",
       "      <td>300472</td>\n",
       "      <td>新元科技</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2796</th>\n",
       "      <td>603989</td>\n",
       "      <td>艾华集团</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2797</th>\n",
       "      <td>300477</td>\n",
       "      <td>合纵科技</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2798</th>\n",
       "      <td>000001</td>\n",
       "      <td>平安银行</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2799</th>\n",
       "      <td>300481</td>\n",
       "      <td>濮阳惠成</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2800</th>\n",
       "      <td>300486</td>\n",
       "      <td>东杰智能</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2801</th>\n",
       "      <td>300490</td>\n",
       "      <td>华自科技</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2802</th>\n",
       "      <td>300494</td>\n",
       "      <td>盛天网络</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2803</th>\n",
       "      <td>600958</td>\n",
       "      <td>东方证券</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2804</th>\n",
       "      <td>601169</td>\n",
       "      <td>北京银行</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2805</th>\n",
       "      <td>601288</td>\n",
       "      <td>农业银行</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2806</th>\n",
       "      <td>002735</td>\n",
       "      <td>王子新材</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0672</td>\n",
       "      <td>252.9985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2807</th>\n",
       "      <td>002739</td>\n",
       "      <td>万达电影</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2808</th>\n",
       "      <td>002748</td>\n",
       "      <td>世龙实业</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2809</th>\n",
       "      <td>002752</td>\n",
       "      <td>昇兴股份</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2810</th>\n",
       "      <td>002757</td>\n",
       "      <td>南兴股份</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2811</th>\n",
       "      <td>002761</td>\n",
       "      <td>多喜爱</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2812</th>\n",
       "      <td>002766</td>\n",
       "      <td>*ST索菱</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2813</th>\n",
       "      <td>002770</td>\n",
       "      <td>科迪乳业</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2814</th>\n",
       "      <td>002775</td>\n",
       "      <td>文科园林</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2815</th>\n",
       "      <td>002779</td>\n",
       "      <td>中坚科技</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2816</th>\n",
       "      <td>603017</td>\n",
       "      <td>中衡设计</td>\n",
       "      <td>2.5707</td>\n",
       "      <td>105.0298</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.1948</td>\n",
       "      <td>225.9792</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2817</th>\n",
       "      <td>603026</td>\n",
       "      <td>石大胜华</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2818</th>\n",
       "      <td>600790</td>\n",
       "      <td>轻纺城</td>\n",
       "      <td>143.7212</td>\n",
       "      <td>1.8786</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.3926</td>\n",
       "      <td>687.7229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2819</th>\n",
       "      <td>002142</td>\n",
       "      <td>宁波银行</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2820</th>\n",
       "      <td>603315</td>\n",
       "      <td>福鞍股份</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2821</th>\n",
       "      <td>300059</td>\n",
       "      <td>东方财富</td>\n",
       "      <td>5.0450</td>\n",
       "      <td>53.5183</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1047</td>\n",
       "      <td>2578.7966</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2822 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        code   name  arturnover  arturndays  inventory_turnover  \\\n",
       "0     600605   汇通能源      5.7747     46.7557         102298.4414   \n",
       "1     002649   博彦科技      3.0000     90.0000          37127.2743   \n",
       "2     002707   众信旅游     20.0313     13.4789           7704.9730   \n",
       "3     002039   黔源电力      7.8636     34.3354           6360.2514   \n",
       "4     300071   华谊嘉信      1.8090    149.2537           3002.9073   \n",
       "5     002357   富临运业     53.2925      5.0664           2947.0547   \n",
       "6     002400   省广集团      4.7772     56.5185           2592.9770   \n",
       "7     000415   渤海租赁      8.1159     33.2680           1608.9875   \n",
       "8     603056   德邦股份     30.3940      8.8833           1217.1230   \n",
       "9     600897   厦门空港      5.1100     52.8376           1093.2727   \n",
       "10    002238   天威视讯     15.5591     17.3532            903.7139   \n",
       "11    000068   华控赛格      0.1597   1690.6700            731.1300   \n",
       "12    300347   泰格医药      2.2217    121.5286            728.8232   \n",
       "13    000089   深圳机场      4.9080     55.0122            516.1776   \n",
       "14    600452   涪陵电力    733.7627      0.3680            503.8469   \n",
       "15    002210  *ST飞马     24.1954     11.1591            496.0065   \n",
       "16    300170   汉得信息      1.6666    162.0065            390.7866   \n",
       "17    600995   文山电力     33.6387      8.0265            385.9168   \n",
       "18    601519    大智慧      7.9374     34.0162            367.4597   \n",
       "19    600221   海航控股     45.5567      5.9267            323.0456   \n",
       "20    000061    农产品     21.5687     12.5181            297.1456   \n",
       "21    600131   岷江水电    379.1344      0.7121            263.3637   \n",
       "22    601598   中国外运      4.6638     57.8927            259.0900   \n",
       "23    000791   甘肃电投      6.8075     39.6621            229.9359   \n",
       "24    300383   光环新网      7.6201     35.4326            213.4395   \n",
       "25    601518   吉林高速         NaN         NaN            197.4238   \n",
       "26    600505   西昌电力     10.2375     26.3736            179.0883   \n",
       "27    600012   皖通高速         NaN         NaN            176.4436   \n",
       "28    600652  *ST游久      8.3670     32.2696            173.3283   \n",
       "29    300052    中青宝      2.8077     96.1641            168.3620   \n",
       "...      ...    ...         ...         ...                 ...   \n",
       "2792  603901   永创智能         NaN         NaN                 NaN   \n",
       "2793  300468   四方精创         NaN         NaN                 NaN   \n",
       "2794  603968   醋化股份         NaN         NaN                 NaN   \n",
       "2795  300472   新元科技         NaN         NaN                 NaN   \n",
       "2796  603989   艾华集团         NaN         NaN                 NaN   \n",
       "2797  300477   合纵科技         NaN         NaN                 NaN   \n",
       "2798  000001   平安银行         NaN         NaN                 NaN   \n",
       "2799  300481   濮阳惠成         NaN         NaN                 NaN   \n",
       "2800  300486   东杰智能         NaN         NaN                 NaN   \n",
       "2801  300490   华自科技         NaN         NaN                 NaN   \n",
       "2802  300494   盛天网络         NaN         NaN                 NaN   \n",
       "2803  600958   东方证券         NaN         NaN                 NaN   \n",
       "2804  601169   北京银行         NaN         NaN                 NaN   \n",
       "2805  601288   农业银行         NaN         NaN                 NaN   \n",
       "2806  002735   王子新材         NaN         NaN                 NaN   \n",
       "2807  002739   万达电影         NaN         NaN                 NaN   \n",
       "2808  002748   世龙实业         NaN         NaN                 NaN   \n",
       "2809  002752   昇兴股份         NaN         NaN                 NaN   \n",
       "2810  002757   南兴股份         NaN         NaN                 NaN   \n",
       "2811  002761    多喜爱         NaN         NaN                 NaN   \n",
       "2812  002766  *ST索菱         NaN         NaN                 NaN   \n",
       "2813  002770   科迪乳业         NaN         NaN                 NaN   \n",
       "2814  002775   文科园林         NaN         NaN                 NaN   \n",
       "2815  002779   中坚科技         NaN         NaN                 NaN   \n",
       "2816  603017   中衡设计      2.5707    105.0298                 NaN   \n",
       "2817  603026   石大胜华         NaN         NaN                 NaN   \n",
       "2818  600790    轻纺城    143.7212      1.8786                 NaN   \n",
       "2819  002142   宁波银行         NaN         NaN                 NaN   \n",
       "2820  603315   福鞍股份         NaN         NaN                 NaN   \n",
       "2821  300059   东方财富      5.0450     53.5183                 NaN   \n",
       "\n",
       "      inventory_days  currentasset_turnover  currentasset_days  \n",
       "0             0.0026                 3.9518            68.3233  \n",
       "1             0.0073                 1.0532           256.3616  \n",
       "2             0.0350                 3.7006            72.9611  \n",
       "3             0.0425                 2.0979           128.7001  \n",
       "4             0.0899                 1.4096           191.5437  \n",
       "5             0.0916                 0.5839           462.4079  \n",
       "6             0.1041                 1.5046           179.4497  \n",
       "7             0.1678                 0.4496           600.5338  \n",
       "8             0.2218                 5.7985            46.5638  \n",
       "9             0.2470                 0.6361           424.4616  \n",
       "10            0.2988                 0.8321           324.4802  \n",
       "11            0.3693                 0.1143          2362.2047  \n",
       "12            0.3705                 0.5963           452.7922  \n",
       "13            0.5231                 1.1366           237.5506  \n",
       "14            0.5359                 8.5228            31.6797  \n",
       "15            0.5443                 1.4342           188.2583  \n",
       "16            0.6909                 0.5860           460.7509  \n",
       "17            0.6996                 4.0343            66.9261  \n",
       "18            0.7348                 0.2734           987.5640  \n",
       "19            0.8358                 0.9988           270.3244  \n",
       "20            0.9086                 0.4582           589.2623  \n",
       "21            1.0252                 2.5380           106.3830  \n",
       "22            1.0421                 2.0358           132.6260  \n",
       "23            1.1742                 1.5252           177.0260  \n",
       "24            1.2650                 1.2123           222.7171  \n",
       "25            1.3676                 0.5841           462.2496  \n",
       "26            1.5076                 2.0458           131.9777  \n",
       "27            1.5302                 1.0015           269.5956  \n",
       "28            1.5577                 1.6628           162.3767  \n",
       "29            1.6037                 0.6731           401.1291  \n",
       "...              ...                    ...                ...  \n",
       "2792             NaN                    NaN                NaN  \n",
       "2793             NaN                    NaN                NaN  \n",
       "2794             NaN                    NaN                NaN  \n",
       "2795             NaN                    NaN                NaN  \n",
       "2796             NaN                    NaN                NaN  \n",
       "2797             NaN                    NaN                NaN  \n",
       "2798             NaN                    NaN                NaN  \n",
       "2799             NaN                    NaN                NaN  \n",
       "2800             NaN                    NaN                NaN  \n",
       "2801             NaN                    NaN                NaN  \n",
       "2802             NaN                    NaN                NaN  \n",
       "2803             NaN                    NaN                NaN  \n",
       "2804             NaN                    NaN                NaN  \n",
       "2805             NaN                    NaN                NaN  \n",
       "2806             NaN                 1.0672           252.9985  \n",
       "2807             NaN                    NaN                NaN  \n",
       "2808             NaN                    NaN                NaN  \n",
       "2809             NaN                    NaN                NaN  \n",
       "2810             NaN                    NaN                NaN  \n",
       "2811             NaN                    NaN                NaN  \n",
       "2812             NaN                    NaN                NaN  \n",
       "2813             NaN                    NaN                NaN  \n",
       "2814             NaN                    NaN                NaN  \n",
       "2815             NaN                    NaN                NaN  \n",
       "2816             NaN                 1.1948           225.9792  \n",
       "2817             NaN                    NaN                NaN  \n",
       "2818             NaN                 0.3926           687.7229  \n",
       "2819             NaN                    NaN                NaN  \n",
       "2820             NaN                    NaN                NaN  \n",
       "2821             NaN                 0.1047          2578.7966  \n",
       "\n",
       "[2822 rows x 8 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import tushare as ts\n",
    "\n",
    "# 获取2014年第3季度的营运能力数据\n",
    "df4 = ts.get_operation_data(2014,3)\n",
    "df4"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "返回值说明：\n",
    "- arturnover：应收账款周转率（次）\n",
    "- arturndays：应收账款周转天数（天）\n",
    "- inventory_turnover：存货周转率（次）\n",
    "- inventory_days：存货周转天数（天）\n",
    "- currentasset_turnover：流动资产周转率（次）\n",
    "- currentasset_days：流动资产周转天数（天）"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 成长能力\n",
    "按年度、季度获取成长能力数据。"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[Getting data:]############################################"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>name</th>\n",
       "      <th>mbrg</th>\n",
       "      <th>nprg</th>\n",
       "      <th>nav</th>\n",
       "      <th>targ</th>\n",
       "      <th>epsg</th>\n",
       "      <th>seg</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>600566</td>\n",
       "      <td>济川药业</td>\n",
       "      <td>1479.2517</td>\n",
       "      <td>84495.0729</td>\n",
       "      <td>338.3363</td>\n",
       "      <td>200.8906</td>\n",
       "      <td>16133.3333</td>\n",
       "      <td>339.3248</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>600105</td>\n",
       "      <td>永鼎股份</td>\n",
       "      <td>39.5802</td>\n",
       "      <td>24575.3671</td>\n",
       "      <td>8.6028</td>\n",
       "      <td>-34.6496</td>\n",
       "      <td>437.0968</td>\n",
       "      <td>13.7498</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>600598</td>\n",
       "      <td>北大荒</td>\n",
       "      <td>-40.8583</td>\n",
       "      <td>7030.3488</td>\n",
       "      <td>10.3021</td>\n",
       "      <td>-38.2057</td>\n",
       "      <td>1112.5000</td>\n",
       "      <td>13.6134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>600483</td>\n",
       "      <td>福能股份</td>\n",
       "      <td>354.7807</td>\n",
       "      <td>6718.1981</td>\n",
       "      <td>671.6278</td>\n",
       "      <td>1085.3524</td>\n",
       "      <td>2234.0807</td>\n",
       "      <td>649.1479</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>000678</td>\n",
       "      <td>襄阳轴承</td>\n",
       "      <td>67.0414</td>\n",
       "      <td>6565.1816</td>\n",
       "      <td>5.0957</td>\n",
       "      <td>22.7679</td>\n",
       "      <td>3400.0000</td>\n",
       "      <td>1.4472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>600822</td>\n",
       "      <td>上海物贸</td>\n",
       "      <td>-27.9066</td>\n",
       "      <td>6005.3197</td>\n",
       "      <td>1.5399</td>\n",
       "      <td>-16.5748</td>\n",
       "      <td>-102.3377</td>\n",
       "      <td>1.3843</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>300134</td>\n",
       "      <td>大富科技</td>\n",
       "      <td>52.2005</td>\n",
       "      <td>5397.1468</td>\n",
       "      <td>15.9320</td>\n",
       "      <td>26.7249</td>\n",
       "      <td>6200.0000</td>\n",
       "      <td>17.3278</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>600730</td>\n",
       "      <td>中国高科</td>\n",
       "      <td>137.1223</td>\n",
       "      <td>4068.2816</td>\n",
       "      <td>67.4825</td>\n",
       "      <td>15.0042</td>\n",
       "      <td>3697.0803</td>\n",
       "      <td>73.5699</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>000985</td>\n",
       "      <td>大庆华科</td>\n",
       "      <td>35.0846</td>\n",
       "      <td>3106.1411</td>\n",
       "      <td>7.3651</td>\n",
       "      <td>7.2652</td>\n",
       "      <td>2920.0000</td>\n",
       "      <td>7.3651</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>300208</td>\n",
       "      <td>青岛中程</td>\n",
       "      <td>263.2526</td>\n",
       "      <td>2510.8422</td>\n",
       "      <td>12.2521</td>\n",
       "      <td>3.4033</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.6902</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>603077</td>\n",
       "      <td>和邦生物</td>\n",
       "      <td>34.8709</td>\n",
       "      <td>1548.3749</td>\n",
       "      <td>46.0789</td>\n",
       "      <td>60.1127</td>\n",
       "      <td>674.1935</td>\n",
       "      <td>46.0789</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>000557</td>\n",
       "      <td>西部创业</td>\n",
       "      <td>-14.6439</td>\n",
       "      <td>1547.2698</td>\n",
       "      <td>5.6215</td>\n",
       "      <td>-3.2179</td>\n",
       "      <td>1525.0000</td>\n",
       "      <td>5.6845</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>000810</td>\n",
       "      <td>创维数字</td>\n",
       "      <td>200.6708</td>\n",
       "      <td>1529.8586</td>\n",
       "      <td>193.3521</td>\n",
       "      <td>239.7402</td>\n",
       "      <td>908.9030</td>\n",
       "      <td>276.8732</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>002171</td>\n",
       "      <td>楚江新材</td>\n",
       "      <td>113.7328</td>\n",
       "      <td>1527.3439</td>\n",
       "      <td>78.0597</td>\n",
       "      <td>64.6883</td>\n",
       "      <td>NaN</td>\n",
       "      <td>78.5960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>000582</td>\n",
       "      <td>北部湾港</td>\n",
       "      <td>202.0920</td>\n",
       "      <td>1471.9331</td>\n",
       "      <td>672.5117</td>\n",
       "      <td>543.5511</td>\n",
       "      <td>165.3333</td>\n",
       "      <td>646.8809</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>002466</td>\n",
       "      <td>天齐锂业</td>\n",
       "      <td>214.5170</td>\n",
       "      <td>1344.9710</td>\n",
       "      <td>398.5037</td>\n",
       "      <td>303.6132</td>\n",
       "      <td>193.3333</td>\n",
       "      <td>196.5900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>300080</td>\n",
       "      <td>易成新能</td>\n",
       "      <td>38.2931</td>\n",
       "      <td>1240.4295</td>\n",
       "      <td>13.9755</td>\n",
       "      <td>22.1299</td>\n",
       "      <td>585.3503</td>\n",
       "      <td>14.9078</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>002505</td>\n",
       "      <td>大康农业</td>\n",
       "      <td>-28.1840</td>\n",
       "      <td>1230.6356</td>\n",
       "      <td>587.7240</td>\n",
       "      <td>384.6368</td>\n",
       "      <td>1000.0000</td>\n",
       "      <td>613.0112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>600398</td>\n",
       "      <td>海澜之家</td>\n",
       "      <td>647.8935</td>\n",
       "      <td>1217.1893</td>\n",
       "      <td>189.2197</td>\n",
       "      <td>531.6968</td>\n",
       "      <td>94.7368</td>\n",
       "      <td>193.7572</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>002354</td>\n",
       "      <td>天神娱乐</td>\n",
       "      <td>14.4700</td>\n",
       "      <td>1131.5618</td>\n",
       "      <td>18.6228</td>\n",
       "      <td>-33.8445</td>\n",
       "      <td>941.6667</td>\n",
       "      <td>18.8189</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>300148</td>\n",
       "      <td>天舟文化</td>\n",
       "      <td>58.4586</td>\n",
       "      <td>1044.7883</td>\n",
       "      <td>222.5776</td>\n",
       "      <td>180.3578</td>\n",
       "      <td>340.0000</td>\n",
       "      <td>225.1935</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>000735</td>\n",
       "      <td>罗牛山</td>\n",
       "      <td>7.2002</td>\n",
       "      <td>1040.5827</td>\n",
       "      <td>1.6552</td>\n",
       "      <td>-6.9748</td>\n",
       "      <td>1127.4510</td>\n",
       "      <td>2.7255</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>000835</td>\n",
       "      <td>长城动漫</td>\n",
       "      <td>-56.6731</td>\n",
       "      <td>979.2065</td>\n",
       "      <td>-0.7170</td>\n",
       "      <td>-15.8246</td>\n",
       "      <td>996.2264</td>\n",
       "      <td>-0.7150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>000560</td>\n",
       "      <td>我爱我家</td>\n",
       "      <td>4.6268</td>\n",
       "      <td>961.1997</td>\n",
       "      <td>9.4986</td>\n",
       "      <td>-13.3026</td>\n",
       "      <td>395.5414</td>\n",
       "      <td>17.2749</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>002240</td>\n",
       "      <td>威华股份</td>\n",
       "      <td>-1.0929</td>\n",
       "      <td>940.1042</td>\n",
       "      <td>0.7467</td>\n",
       "      <td>-3.6525</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.8409</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>002562</td>\n",
       "      <td>兄弟科技</td>\n",
       "      <td>0.9611</td>\n",
       "      <td>910.9192</td>\n",
       "      <td>3.8573</td>\n",
       "      <td>-2.3125</td>\n",
       "      <td>333.3333</td>\n",
       "      <td>4.9106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>000034</td>\n",
       "      <td>神州数码</td>\n",
       "      <td>0.3839</td>\n",
       "      <td>832.6061</td>\n",
       "      <td>66.9160</td>\n",
       "      <td>53.9997</td>\n",
       "      <td>856.2500</td>\n",
       "      <td>66.9160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>300201</td>\n",
       "      <td>海伦哲</td>\n",
       "      <td>36.7279</td>\n",
       "      <td>806.8294</td>\n",
       "      <td>1.7466</td>\n",
       "      <td>7.1851</td>\n",
       "      <td>286.6667</td>\n",
       "      <td>1.7393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>002149</td>\n",
       "      <td>西部材料</td>\n",
       "      <td>-20.5391</td>\n",
       "      <td>738.0913</td>\n",
       "      <td>7.2442</td>\n",
       "      <td>6.7573</td>\n",
       "      <td>-100.7000</td>\n",
       "      <td>4.7726</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>600645</td>\n",
       "      <td>中源协和</td>\n",
       "      <td>14.8606</td>\n",
       "      <td>720.8918</td>\n",
       "      <td>112.3520</td>\n",
       "      <td>13.4709</td>\n",
       "      <td>4700.0000</td>\n",
       "      <td>253.7276</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2580</th>\n",
       "      <td>000927</td>\n",
       "      <td>一汽夏利</td>\n",
       "      <td>-45.8569</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-29.9881</td>\n",
       "      <td>-14.4397</td>\n",
       "      <td>600.4823</td>\n",
       "      <td>-30.2289</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2581</th>\n",
       "      <td>000931</td>\n",
       "      <td>中关村</td>\n",
       "      <td>-12.2122</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-19.5066</td>\n",
       "      <td>4.3513</td>\n",
       "      <td>74.9004</td>\n",
       "      <td>-20.1932</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2582</th>\n",
       "      <td>600071</td>\n",
       "      <td>凤凰光学</td>\n",
       "      <td>30.6998</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-4.5235</td>\n",
       "      <td>15.6857</td>\n",
       "      <td>77.2222</td>\n",
       "      <td>-7.4560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2583</th>\n",
       "      <td>000948</td>\n",
       "      <td>南天信息</td>\n",
       "      <td>-13.0554</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1878</td>\n",
       "      <td>1.4046</td>\n",
       "      <td>-28.0630</td>\n",
       "      <td>0.3458</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2584</th>\n",
       "      <td>600075</td>\n",
       "      <td>新疆天业</td>\n",
       "      <td>12.9110</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-2.6641</td>\n",
       "      <td>-14.2302</td>\n",
       "      <td>-137.0370</td>\n",
       "      <td>-3.0186</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2585</th>\n",
       "      <td>600877</td>\n",
       "      <td>*ST嘉陵</td>\n",
       "      <td>-12.1429</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-23.9516</td>\n",
       "      <td>-7.8790</td>\n",
       "      <td>-111.5228</td>\n",
       "      <td>-21.7373</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2586</th>\n",
       "      <td>000952</td>\n",
       "      <td>广济药业</td>\n",
       "      <td>4.9329</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-8.8020</td>\n",
       "      <td>-3.0982</td>\n",
       "      <td>-24400.0000</td>\n",
       "      <td>-8.2685</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2587</th>\n",
       "      <td>002306</td>\n",
       "      <td>*ST云网</td>\n",
       "      <td>-12.6980</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-36.6470</td>\n",
       "      <td>-18.6066</td>\n",
       "      <td>-68.4211</td>\n",
       "      <td>-44.6498</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2588</th>\n",
       "      <td>600890</td>\n",
       "      <td>中房股份</td>\n",
       "      <td>144.3640</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.3904</td>\n",
       "      <td>15.9669</td>\n",
       "      <td>-50.0000</td>\n",
       "      <td>6.4237</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2589</th>\n",
       "      <td>002314</td>\n",
       "      <td>南山控股</td>\n",
       "      <td>-20.7091</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-9.5581</td>\n",
       "      <td>-12.0961</td>\n",
       "      <td>382.5714</td>\n",
       "      <td>-9.3076</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2590</th>\n",
       "      <td>000971</td>\n",
       "      <td>*ST高升</td>\n",
       "      <td>-54.6997</td>\n",
       "      <td>NaN</td>\n",
       "      <td>192.3858</td>\n",
       "      <td>-63.2429</td>\n",
       "      <td>-36.4583</td>\n",
       "      <td>192.3858</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2591</th>\n",
       "      <td>000976</td>\n",
       "      <td>华铁股份</td>\n",
       "      <td>-9.7032</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-24.7038</td>\n",
       "      <td>-16.1369</td>\n",
       "      <td>30.3538</td>\n",
       "      <td>-24.9850</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2592</th>\n",
       "      <td>000504</td>\n",
       "      <td>*ST生物</td>\n",
       "      <td>-19.4841</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>57.7790</td>\n",
       "      <td>-16.3065</td>\n",
       "      <td>-95.6076</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2593</th>\n",
       "      <td>600962</td>\n",
       "      <td>国投中鲁</td>\n",
       "      <td>-29.3325</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-7.5784</td>\n",
       "      <td>15.1208</td>\n",
       "      <td>-19.8381</td>\n",
       "      <td>-8.7321</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2594</th>\n",
       "      <td>000509</td>\n",
       "      <td>华塑控股</td>\n",
       "      <td>-1.0285</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>39.4106</td>\n",
       "      <td>-113.4668</td>\n",
       "      <td>-147.9698</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2595</th>\n",
       "      <td>300283</td>\n",
       "      <td>温州宏丰</td>\n",
       "      <td>0.7985</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.0858</td>\n",
       "      <td>14.4001</td>\n",
       "      <td>-383.3333</td>\n",
       "      <td>6.0858</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2596</th>\n",
       "      <td>600538</td>\n",
       "      <td>国发股份</td>\n",
       "      <td>-9.8047</td>\n",
       "      <td>NaN</td>\n",
       "      <td>813.9380</td>\n",
       "      <td>58.4245</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>4391.5261</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2597</th>\n",
       "      <td>000520</td>\n",
       "      <td>长航凤凰</td>\n",
       "      <td>-25.9458</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-88.7232</td>\n",
       "      <td>-684.1242</td>\n",
       "      <td>-104.0007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2598</th>\n",
       "      <td>002346</td>\n",
       "      <td>柘中股份</td>\n",
       "      <td>-15.4843</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.9161</td>\n",
       "      <td>-6.0362</td>\n",
       "      <td>-116.6667</td>\n",
       "      <td>0.9161</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2599</th>\n",
       "      <td>600555</td>\n",
       "      <td>海航创新</td>\n",
       "      <td>-83.0809</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.4927</td>\n",
       "      <td>-1.4131</td>\n",
       "      <td>-128.5714</td>\n",
       "      <td>5.2152</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2600</th>\n",
       "      <td>600131</td>\n",
       "      <td>岷江水电</td>\n",
       "      <td>-1.5464</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11.7361</td>\n",
       "      <td>-0.0702</td>\n",
       "      <td>-223.7081</td>\n",
       "      <td>12.3818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2601</th>\n",
       "      <td>600136</td>\n",
       "      <td>当代明诚</td>\n",
       "      <td>-14.5082</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.8384</td>\n",
       "      <td>-1.5884</td>\n",
       "      <td>57.1429</td>\n",
       "      <td>0.8778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2602</th>\n",
       "      <td>601003</td>\n",
       "      <td>柳钢股份</td>\n",
       "      <td>-1.4037</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.3452</td>\n",
       "      <td>0.1773</td>\n",
       "      <td>-8060.0000</td>\n",
       "      <td>6.3452</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2603</th>\n",
       "      <td>002362</td>\n",
       "      <td>汉王科技</td>\n",
       "      <td>25.2563</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-17.0456</td>\n",
       "      <td>-15.5031</td>\n",
       "      <td>-106.6667</td>\n",
       "      <td>-16.9716</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2604</th>\n",
       "      <td>002708</td>\n",
       "      <td>光洋股份</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>83.7763</td>\n",
       "      <td>48.1063</td>\n",
       "      <td>-26.4706</td>\n",
       "      <td>83.7763</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2605</th>\n",
       "      <td>600152</td>\n",
       "      <td>维科技术</td>\n",
       "      <td>-43.2192</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-9.2987</td>\n",
       "      <td>-20.9275</td>\n",
       "      <td>95.1983</td>\n",
       "      <td>-2.7616</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2606</th>\n",
       "      <td>002370</td>\n",
       "      <td>亚太药业</td>\n",
       "      <td>29.3005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.9569</td>\n",
       "      <td>3.3312</td>\n",
       "      <td>-800.0000</td>\n",
       "      <td>4.9569</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2607</th>\n",
       "      <td>601108</td>\n",
       "      <td>财通证券</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.6937</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2608</th>\n",
       "      <td>600188</td>\n",
       "      <td>兖州煤业</td>\n",
       "      <td>15.6266</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.7188</td>\n",
       "      <td>14.8930</td>\n",
       "      <td>-431.9967</td>\n",
       "      <td>2.0661</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2609</th>\n",
       "      <td>000597</td>\n",
       "      <td>东北制药</td>\n",
       "      <td>13.3195</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.6891</td>\n",
       "      <td>21.3738</td>\n",
       "      <td>-166.2551</td>\n",
       "      <td>65.8307</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2610 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        code   name       mbrg        nprg       nav       targ        epsg  \\\n",
       "0     600566   济川药业  1479.2517  84495.0729  338.3363   200.8906  16133.3333   \n",
       "1     600105   永鼎股份    39.5802  24575.3671    8.6028   -34.6496    437.0968   \n",
       "2     600598    北大荒   -40.8583   7030.3488   10.3021   -38.2057   1112.5000   \n",
       "3     600483   福能股份   354.7807   6718.1981  671.6278  1085.3524   2234.0807   \n",
       "4     000678   襄阳轴承    67.0414   6565.1816    5.0957    22.7679   3400.0000   \n",
       "5     600822   上海物贸   -27.9066   6005.3197    1.5399   -16.5748   -102.3377   \n",
       "6     300134   大富科技    52.2005   5397.1468   15.9320    26.7249   6200.0000   \n",
       "7     600730   中国高科   137.1223   4068.2816   67.4825    15.0042   3697.0803   \n",
       "8     000985   大庆华科    35.0846   3106.1411    7.3651     7.2652   2920.0000   \n",
       "9     300208   青岛中程   263.2526   2510.8422   12.2521     3.4033         NaN   \n",
       "10    603077   和邦生物    34.8709   1548.3749   46.0789    60.1127    674.1935   \n",
       "11    000557   西部创业   -14.6439   1547.2698    5.6215    -3.2179   1525.0000   \n",
       "12    000810   创维数字   200.6708   1529.8586  193.3521   239.7402    908.9030   \n",
       "13    002171   楚江新材   113.7328   1527.3439   78.0597    64.6883         NaN   \n",
       "14    000582   北部湾港   202.0920   1471.9331  672.5117   543.5511    165.3333   \n",
       "15    002466   天齐锂业   214.5170   1344.9710  398.5037   303.6132    193.3333   \n",
       "16    300080   易成新能    38.2931   1240.4295   13.9755    22.1299    585.3503   \n",
       "17    002505   大康农业   -28.1840   1230.6356  587.7240   384.6368   1000.0000   \n",
       "18    600398   海澜之家   647.8935   1217.1893  189.2197   531.6968     94.7368   \n",
       "19    002354   天神娱乐    14.4700   1131.5618   18.6228   -33.8445    941.6667   \n",
       "20    300148   天舟文化    58.4586   1044.7883  222.5776   180.3578    340.0000   \n",
       "21    000735    罗牛山     7.2002   1040.5827    1.6552    -6.9748   1127.4510   \n",
       "22    000835   长城动漫   -56.6731    979.2065   -0.7170   -15.8246    996.2264   \n",
       "23    000560   我爱我家     4.6268    961.1997    9.4986   -13.3026    395.5414   \n",
       "24    002240   威华股份    -1.0929    940.1042    0.7467    -3.6525      0.0000   \n",
       "25    002562   兄弟科技     0.9611    910.9192    3.8573    -2.3125    333.3333   \n",
       "26    000034   神州数码     0.3839    832.6061   66.9160    53.9997    856.2500   \n",
       "27    300201    海伦哲    36.7279    806.8294    1.7466     7.1851    286.6667   \n",
       "28    002149   西部材料   -20.5391    738.0913    7.2442     6.7573   -100.7000   \n",
       "29    600645   中源协和    14.8606    720.8918  112.3520    13.4709   4700.0000   \n",
       "...      ...    ...        ...         ...       ...        ...         ...   \n",
       "2580  000927   一汽夏利   -45.8569         NaN  -29.9881   -14.4397    600.4823   \n",
       "2581  000931    中关村   -12.2122         NaN  -19.5066     4.3513     74.9004   \n",
       "2582  600071   凤凰光学    30.6998         NaN   -4.5235    15.6857     77.2222   \n",
       "2583  000948   南天信息   -13.0554         NaN    0.1878     1.4046    -28.0630   \n",
       "2584  600075   新疆天业    12.9110         NaN   -2.6641   -14.2302   -137.0370   \n",
       "2585  600877  *ST嘉陵   -12.1429         NaN  -23.9516    -7.8790   -111.5228   \n",
       "2586  000952   广济药业     4.9329         NaN   -8.8020    -3.0982 -24400.0000   \n",
       "2587  002306  *ST云网   -12.6980         NaN  -36.6470   -18.6066    -68.4211   \n",
       "2588  600890   中房股份   144.3640         NaN    6.3904    15.9669    -50.0000   \n",
       "2589  002314   南山控股   -20.7091         NaN   -9.5581   -12.0961    382.5714   \n",
       "2590  000971  *ST高升   -54.6997         NaN  192.3858   -63.2429    -36.4583   \n",
       "2591  000976   华铁股份    -9.7032         NaN  -24.7038   -16.1369     30.3538   \n",
       "2592  000504  *ST生物   -19.4841         NaN       NaN    57.7790    -16.3065   \n",
       "2593  600962   国投中鲁   -29.3325         NaN   -7.5784    15.1208    -19.8381   \n",
       "2594  000509   华塑控股    -1.0285         NaN       NaN    39.4106   -113.4668   \n",
       "2595  300283   温州宏丰     0.7985         NaN    6.0858    14.4001   -383.3333   \n",
       "2596  600538   国发股份    -9.8047         NaN  813.9380    58.4245     50.0000   \n",
       "2597  000520   长航凤凰   -25.9458         NaN       NaN   -88.7232   -684.1242   \n",
       "2598  002346   柘中股份   -15.4843         NaN    0.9161    -6.0362   -116.6667   \n",
       "2599  600555   海航创新   -83.0809         NaN    5.4927    -1.4131   -128.5714   \n",
       "2600  600131   岷江水电    -1.5464         NaN   11.7361    -0.0702   -223.7081   \n",
       "2601  600136   当代明诚   -14.5082         NaN    0.8384    -1.5884     57.1429   \n",
       "2602  601003   柳钢股份    -1.4037         NaN    6.3452     0.1773  -8060.0000   \n",
       "2603  002362   汉王科技    25.2563         NaN  -17.0456   -15.5031   -106.6667   \n",
       "2604  002708   光洋股份        NaN         NaN   83.7763    48.1063    -26.4706   \n",
       "2605  600152   维科技术   -43.2192         NaN   -9.2987   -20.9275     95.1983   \n",
       "2606  002370   亚太药业    29.3005         NaN    4.9569     3.3312   -800.0000   \n",
       "2607  601108   财通证券        NaN         NaN       NaN        NaN         NaN   \n",
       "2608  600188   兖州煤业    15.6266         NaN    7.7188    14.8930   -431.9967   \n",
       "2609  000597   东北制药    13.3195         NaN   62.6891    21.3738   -166.2551   \n",
       "\n",
       "            seg  \n",
       "0      339.3248  \n",
       "1       13.7498  \n",
       "2       13.6134  \n",
       "3      649.1479  \n",
       "4        1.4472  \n",
       "5        1.3843  \n",
       "6       17.3278  \n",
       "7       73.5699  \n",
       "8        7.3651  \n",
       "9       10.6902  \n",
       "10      46.0789  \n",
       "11       5.6845  \n",
       "12     276.8732  \n",
       "13      78.5960  \n",
       "14     646.8809  \n",
       "15     196.5900  \n",
       "16      14.9078  \n",
       "17     613.0112  \n",
       "18     193.7572  \n",
       "19      18.8189  \n",
       "20     225.1935  \n",
       "21       2.7255  \n",
       "22      -0.7150  \n",
       "23      17.2749  \n",
       "24       0.8409  \n",
       "25       4.9106  \n",
       "26      66.9160  \n",
       "27       1.7393  \n",
       "28       4.7726  \n",
       "29     253.7276  \n",
       "...         ...  \n",
       "2580   -30.2289  \n",
       "2581   -20.1932  \n",
       "2582    -7.4560  \n",
       "2583     0.3458  \n",
       "2584    -3.0186  \n",
       "2585   -21.7373  \n",
       "2586    -8.2685  \n",
       "2587   -44.6498  \n",
       "2588     6.4237  \n",
       "2589    -9.3076  \n",
       "2590   192.3858  \n",
       "2591   -24.9850  \n",
       "2592   -95.6076  \n",
       "2593    -8.7321  \n",
       "2594  -147.9698  \n",
       "2595     6.0858  \n",
       "2596  4391.5261  \n",
       "2597  -104.0007  \n",
       "2598     0.9161  \n",
       "2599     5.2152  \n",
       "2600    12.3818  \n",
       "2601     0.8778  \n",
       "2602     6.3452  \n",
       "2603   -16.9716  \n",
       "2604    83.7763  \n",
       "2605    -2.7616  \n",
       "2606     4.9569  \n",
       "2607    12.6937  \n",
       "2608     2.0661  \n",
       "2609    65.8307  \n",
       "\n",
       "[2610 rows x 8 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import tushare as ts\n",
    "\n",
    "# 获取2014年第3季度的成长能力数据\n",
    "df5 = ts.get_growth_data(2014,3)\n",
    "df5"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "返回值说明：\n",
    "- mbrg：主营业务收入增长率（%）\n",
    "- nprg：净利润增长率（%）\n",
    "- nav：净资产增长率（%）\n",
    "- targ：总资产增长率（%）\n",
    "- epsg：每股收益增长率（%）\n",
    "- seg：股东权益增长率（%）"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 偿债能力\n",
    "按年度、季度获取成长能力数据。"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[Getting data:]################################################"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>name</th>\n",
       "      <th>currentratio</th>\n",
       "      <th>quickratio</th>\n",
       "      <th>cashratio</th>\n",
       "      <th>icratio</th>\n",
       "      <th>sheqratio</th>\n",
       "      <th>adratio</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>300499</td>\n",
       "      <td>高澜股份</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>2143.4446</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>000166</td>\n",
       "      <td>申万宏源</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>601211</td>\n",
       "      <td>国泰君安</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>002758</td>\n",
       "      <td>华通医药</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>730.4957</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>002762</td>\n",
       "      <td>金发拉比</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>-2932.9999</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>002767</td>\n",
       "      <td>先锋电子</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>-4249.8541</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>002771</td>\n",
       "      <td>真视通</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>4471.6746</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>002776</td>\n",
       "      <td>柏堡龙</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>1124.635</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>002785</td>\n",
       "      <td>万里石</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>194.2025</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>603022</td>\n",
       "      <td>新通联</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>1980.2397</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>603030</td>\n",
       "      <td>全筑股份</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>406.2132</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>603066</td>\n",
       "      <td>音飞储存</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>6824.0699</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>603116</td>\n",
       "      <td>红蜻蜓</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>4312.8851</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>603223</td>\n",
       "      <td>恒通股份</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>459.9094</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>603318</td>\n",
       "      <td>派思股份</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>373.0995</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>603599</td>\n",
       "      <td>广信股份</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>-4539.9404</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>300428</td>\n",
       "      <td>四通新材</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>1374.2235</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>300440</td>\n",
       "      <td>运达科技</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>-13540.0691</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>300444</td>\n",
       "      <td>双杰电气</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>300448</td>\n",
       "      <td>浩云科技</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>570.0995</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>603789</td>\n",
       "      <td>星光农机</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>-7963.6319</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>300452</td>\n",
       "      <td>山河药辅</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>-24652.9</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>603818</td>\n",
       "      <td>曲美家居</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>1227.0919</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>300457</td>\n",
       "      <td>赢合科技</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>3750.4976</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>603866</td>\n",
       "      <td>桃李面包</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>-19004.4158</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>300461</td>\n",
       "      <td>田中精机</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>-8397.1559</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>603918</td>\n",
       "      <td>金桥信息</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>-9.9632</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>300469</td>\n",
       "      <td>信息发展</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>-140.9974</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>300473</td>\n",
       "      <td>德尔股份</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>294726.4277</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>300478</td>\n",
       "      <td>杭州高新</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>781.6471</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2792</th>\n",
       "      <td>600015</td>\n",
       "      <td>华夏银行</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>--</td>\n",
       "      <td>5.4314</td>\n",
       "      <td>94.5686</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2793</th>\n",
       "      <td>600751</td>\n",
       "      <td>海航科技</td>\n",
       "      <td>0.8465</td>\n",
       "      <td>0.8465</td>\n",
       "      <td>60.7049</td>\n",
       "      <td>133.0154</td>\n",
       "      <td>4.9491</td>\n",
       "      <td>95.0509</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2794</th>\n",
       "      <td>000628</td>\n",
       "      <td>高新发展</td>\n",
       "      <td>0.9333</td>\n",
       "      <td>0.7763</td>\n",
       "      <td>26.3339</td>\n",
       "      <td>143.0413</td>\n",
       "      <td>4.6599</td>\n",
       "      <td>95.3401</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2795</th>\n",
       "      <td>600870</td>\n",
       "      <td>ST厦华</td>\n",
       "      <td>0.6038</td>\n",
       "      <td>0.6038</td>\n",
       "      <td>46.9315</td>\n",
       "      <td>-8970.7449</td>\n",
       "      <td>4.6037</td>\n",
       "      <td>95.3963</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2796</th>\n",
       "      <td>600550</td>\n",
       "      <td>保变电气</td>\n",
       "      <td>0.942</td>\n",
       "      <td>0.675</td>\n",
       "      <td>19.4251</td>\n",
       "      <td>214.933</td>\n",
       "      <td>4.4635</td>\n",
       "      <td>95.5365</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2797</th>\n",
       "      <td>000737</td>\n",
       "      <td>ST南风</td>\n",
       "      <td>0.6045</td>\n",
       "      <td>0.4353</td>\n",
       "      <td>17.9707</td>\n",
       "      <td>-46.9677</td>\n",
       "      <td>3.8734</td>\n",
       "      <td>96.1266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2798</th>\n",
       "      <td>002210</td>\n",
       "      <td>*ST飞马</td>\n",
       "      <td>1.0303</td>\n",
       "      <td>1.0275</td>\n",
       "      <td>71.2075</td>\n",
       "      <td>-240.5413</td>\n",
       "      <td>3.8015</td>\n",
       "      <td>96.1985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2799</th>\n",
       "      <td>600800</td>\n",
       "      <td>天津磁卡</td>\n",
       "      <td>0.4416</td>\n",
       "      <td>0.3367</td>\n",
       "      <td>16.0013</td>\n",
       "      <td>-5772.6207</td>\n",
       "      <td>3.5739</td>\n",
       "      <td>96.4261</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2800</th>\n",
       "      <td>600556</td>\n",
       "      <td>ST慧球</td>\n",
       "      <td>1.0583</td>\n",
       "      <td>1.0564</td>\n",
       "      <td>76.6093</td>\n",
       "      <td>-786.2133</td>\n",
       "      <td>2.6397</td>\n",
       "      <td>97.3603</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2801</th>\n",
       "      <td>600179</td>\n",
       "      <td>ST安通</td>\n",
       "      <td>0.6454</td>\n",
       "      <td>0.5517</td>\n",
       "      <td>18.6008</td>\n",
       "      <td>-996.7232</td>\n",
       "      <td>2.3063</td>\n",
       "      <td>97.6937</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2802</th>\n",
       "      <td>600265</td>\n",
       "      <td>ST景谷</td>\n",
       "      <td>0.5891</td>\n",
       "      <td>0.0501</td>\n",
       "      <td>0.7907</td>\n",
       "      <td>-87.8456</td>\n",
       "      <td>2.1418</td>\n",
       "      <td>97.8582</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2803</th>\n",
       "      <td>600338</td>\n",
       "      <td>西藏珠峰</td>\n",
       "      <td>0.4572</td>\n",
       "      <td>0.2635</td>\n",
       "      <td>15.0646</td>\n",
       "      <td>-650.9822</td>\n",
       "      <td>1.997</td>\n",
       "      <td>98.003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2804</th>\n",
       "      <td>600155</td>\n",
       "      <td>华创阳安</td>\n",
       "      <td>0.9229</td>\n",
       "      <td>0.078</td>\n",
       "      <td>0.5457</td>\n",
       "      <td>-44.145</td>\n",
       "      <td>1.843</td>\n",
       "      <td>98.157</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2805</th>\n",
       "      <td>000815</td>\n",
       "      <td>美利云</td>\n",
       "      <td>0.4199</td>\n",
       "      <td>0.0894</td>\n",
       "      <td>0.2458</td>\n",
       "      <td>-1184.4414</td>\n",
       "      <td>1.8001</td>\n",
       "      <td>98.1999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2806</th>\n",
       "      <td>000505</td>\n",
       "      <td>京粮控股</td>\n",
       "      <td>0.6791</td>\n",
       "      <td>0.4338</td>\n",
       "      <td>5.3172</td>\n",
       "      <td>-62.4291</td>\n",
       "      <td>1.2555</td>\n",
       "      <td>98.7445</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2807</th>\n",
       "      <td>600793</td>\n",
       "      <td>宜宾纸业</td>\n",
       "      <td>0.527</td>\n",
       "      <td>0.4856</td>\n",
       "      <td>40.8607</td>\n",
       "      <td>-15.4636</td>\n",
       "      <td>0.9521</td>\n",
       "      <td>99.0479</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2808</th>\n",
       "      <td>600299</td>\n",
       "      <td>安迪苏</td>\n",
       "      <td>0.4132</td>\n",
       "      <td>0.3154</td>\n",
       "      <td>10.3533</td>\n",
       "      <td>-54.3048</td>\n",
       "      <td>0.874</td>\n",
       "      <td>99.126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2809</th>\n",
       "      <td>000504</td>\n",
       "      <td>*ST生物</td>\n",
       "      <td>0.2142</td>\n",
       "      <td>0.2124</td>\n",
       "      <td>2.7743</td>\n",
       "      <td>-2210.9883</td>\n",
       "      <td>0.6891</td>\n",
       "      <td>99.3109</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2810</th>\n",
       "      <td>600306</td>\n",
       "      <td>商业城</td>\n",
       "      <td>0.5498</td>\n",
       "      <td>0.3356</td>\n",
       "      <td>27.9533</td>\n",
       "      <td>-40.5576</td>\n",
       "      <td>0.2164</td>\n",
       "      <td>99.7836</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2811</th>\n",
       "      <td>600608</td>\n",
       "      <td>ST沪科</td>\n",
       "      <td>0.8168</td>\n",
       "      <td>0.6629</td>\n",
       "      <td>4.5909</td>\n",
       "      <td>12.0907</td>\n",
       "      <td>-0.7806</td>\n",
       "      <td>100.781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2812</th>\n",
       "      <td>600715</td>\n",
       "      <td>文投控股</td>\n",
       "      <td>0.8593</td>\n",
       "      <td>0.8593</td>\n",
       "      <td>10.3414</td>\n",
       "      <td>-455.6544</td>\n",
       "      <td>-1.878</td>\n",
       "      <td>101.878</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2813</th>\n",
       "      <td>600876</td>\n",
       "      <td>洛阳玻璃</td>\n",
       "      <td>0.6178</td>\n",
       "      <td>0.2766</td>\n",
       "      <td>15.7382</td>\n",
       "      <td>329.9258</td>\n",
       "      <td>-3.4595</td>\n",
       "      <td>103.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2814</th>\n",
       "      <td>000908</td>\n",
       "      <td>景峰医药</td>\n",
       "      <td>0.4218</td>\n",
       "      <td>0.3201</td>\n",
       "      <td>4.4614</td>\n",
       "      <td>-10422.2431</td>\n",
       "      <td>-3.6359</td>\n",
       "      <td>103.636</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2815</th>\n",
       "      <td>600301</td>\n",
       "      <td>ST南化</td>\n",
       "      <td>0.4626</td>\n",
       "      <td>0.4261</td>\n",
       "      <td>14.2411</td>\n",
       "      <td>-1149.389</td>\n",
       "      <td>-5.4637</td>\n",
       "      <td>105.464</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2816</th>\n",
       "      <td>002015</td>\n",
       "      <td>协鑫能科</td>\n",
       "      <td>0.3631</td>\n",
       "      <td>0.2473</td>\n",
       "      <td>1.812</td>\n",
       "      <td>-468.5055</td>\n",
       "      <td>-6.8884</td>\n",
       "      <td>106.888</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2817</th>\n",
       "      <td>600217</td>\n",
       "      <td>中再资环</td>\n",
       "      <td>0.5296</td>\n",
       "      <td>0.3495</td>\n",
       "      <td>9.9955</td>\n",
       "      <td>-138.6867</td>\n",
       "      <td>-7.2308</td>\n",
       "      <td>107.231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2818</th>\n",
       "      <td>600444</td>\n",
       "      <td>国机通用</td>\n",
       "      <td>0.4872</td>\n",
       "      <td>0.3586</td>\n",
       "      <td>3.3083</td>\n",
       "      <td>-315.4741</td>\n",
       "      <td>-9.7339</td>\n",
       "      <td>109.734</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2819</th>\n",
       "      <td>600228</td>\n",
       "      <td>ST昌九</td>\n",
       "      <td>0.4084</td>\n",
       "      <td>0.338</td>\n",
       "      <td>5.0584</td>\n",
       "      <td>-1.2299</td>\n",
       "      <td>-10.1206</td>\n",
       "      <td>110.121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2820</th>\n",
       "      <td>601975</td>\n",
       "      <td>招商南油</td>\n",
       "      <td>0.1889</td>\n",
       "      <td>0.148</td>\n",
       "      <td>3.4549</td>\n",
       "      <td>-166.75</td>\n",
       "      <td>-21.9253</td>\n",
       "      <td>121.925</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2821</th>\n",
       "      <td>002506</td>\n",
       "      <td>协鑫集成</td>\n",
       "      <td>0.3672</td>\n",
       "      <td>0.3303</td>\n",
       "      <td>5.8918</td>\n",
       "      <td>-693.959</td>\n",
       "      <td>-71.2908</td>\n",
       "      <td>171.291</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2822 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        code   name currentratio quickratio cashratio      icratio sheqratio  \\\n",
       "0     300499   高澜股份           --         --        --    2143.4446        --   \n",
       "1     000166   申万宏源           --         --        --           --        --   \n",
       "2     601211   国泰君安           --         --        --           --        --   \n",
       "3     002758   华通医药           --         --        --     730.4957        --   \n",
       "4     002762   金发拉比           --         --        --   -2932.9999        --   \n",
       "5     002767   先锋电子           --         --        --   -4249.8541        --   \n",
       "6     002771    真视通           --         --        --    4471.6746        --   \n",
       "7     002776    柏堡龙           --         --        --     1124.635        --   \n",
       "8     002785    万里石           --         --        --     194.2025        --   \n",
       "9     603022    新通联           --         --        --    1980.2397        --   \n",
       "10    603030   全筑股份           --         --        --     406.2132        --   \n",
       "11    603066   音飞储存           --         --        --    6824.0699        --   \n",
       "12    603116    红蜻蜓           --         --        --    4312.8851        --   \n",
       "13    603223   恒通股份           --         --        --     459.9094        --   \n",
       "14    603318   派思股份           --         --        --     373.0995        --   \n",
       "15    603599   广信股份           --         --        --   -4539.9404        --   \n",
       "16    300428   四通新材           --         --        --    1374.2235        --   \n",
       "17    300440   运达科技           --         --        --  -13540.0691        --   \n",
       "18    300444   双杰电气           --         --        --           --        --   \n",
       "19    300448   浩云科技           --         --        --     570.0995        --   \n",
       "20    603789   星光农机           --         --        --   -7963.6319        --   \n",
       "21    300452   山河药辅           --         --        --     -24652.9        --   \n",
       "22    603818   曲美家居           --         --        --    1227.0919        --   \n",
       "23    300457   赢合科技           --         --        --    3750.4976        --   \n",
       "24    603866   桃李面包           --         --        --  -19004.4158        --   \n",
       "25    300461   田中精机           --         --        --   -8397.1559        --   \n",
       "26    603918   金桥信息           --         --        --      -9.9632        --   \n",
       "27    300469   信息发展           --         --        --    -140.9974        --   \n",
       "28    300473   德尔股份           --         --        --  294726.4277        --   \n",
       "29    300478   杭州高新           --         --        --     781.6471        --   \n",
       "...      ...    ...          ...        ...       ...          ...       ...   \n",
       "2792  600015   华夏银行           --         --        --           --    5.4314   \n",
       "2793  600751   海航科技       0.8465     0.8465   60.7049     133.0154    4.9491   \n",
       "2794  000628   高新发展       0.9333     0.7763   26.3339     143.0413    4.6599   \n",
       "2795  600870   ST厦华       0.6038     0.6038   46.9315   -8970.7449    4.6037   \n",
       "2796  600550   保变电气        0.942      0.675   19.4251      214.933    4.4635   \n",
       "2797  000737   ST南风       0.6045     0.4353   17.9707     -46.9677    3.8734   \n",
       "2798  002210  *ST飞马       1.0303     1.0275   71.2075    -240.5413    3.8015   \n",
       "2799  600800   天津磁卡       0.4416     0.3367   16.0013   -5772.6207    3.5739   \n",
       "2800  600556   ST慧球       1.0583     1.0564   76.6093    -786.2133    2.6397   \n",
       "2801  600179   ST安通       0.6454     0.5517   18.6008    -996.7232    2.3063   \n",
       "2802  600265   ST景谷       0.5891     0.0501    0.7907     -87.8456    2.1418   \n",
       "2803  600338   西藏珠峰       0.4572     0.2635   15.0646    -650.9822     1.997   \n",
       "2804  600155   华创阳安       0.9229      0.078    0.5457      -44.145     1.843   \n",
       "2805  000815    美利云       0.4199     0.0894    0.2458   -1184.4414    1.8001   \n",
       "2806  000505   京粮控股       0.6791     0.4338    5.3172     -62.4291    1.2555   \n",
       "2807  600793   宜宾纸业        0.527     0.4856   40.8607     -15.4636    0.9521   \n",
       "2808  600299    安迪苏       0.4132     0.3154   10.3533     -54.3048     0.874   \n",
       "2809  000504  *ST生物       0.2142     0.2124    2.7743   -2210.9883    0.6891   \n",
       "2810  600306    商业城       0.5498     0.3356   27.9533     -40.5576    0.2164   \n",
       "2811  600608   ST沪科       0.8168     0.6629    4.5909      12.0907   -0.7806   \n",
       "2812  600715   文投控股       0.8593     0.8593   10.3414    -455.6544    -1.878   \n",
       "2813  600876   洛阳玻璃       0.6178     0.2766   15.7382     329.9258   -3.4595   \n",
       "2814  000908   景峰医药       0.4218     0.3201    4.4614  -10422.2431   -3.6359   \n",
       "2815  600301   ST南化       0.4626     0.4261   14.2411    -1149.389   -5.4637   \n",
       "2816  002015   协鑫能科       0.3631     0.2473     1.812    -468.5055   -6.8884   \n",
       "2817  600217   中再资环       0.5296     0.3495    9.9955    -138.6867   -7.2308   \n",
       "2818  600444   国机通用       0.4872     0.3586    3.3083    -315.4741   -9.7339   \n",
       "2819  600228   ST昌九       0.4084      0.338    5.0584      -1.2299  -10.1206   \n",
       "2820  601975   招商南油       0.1889      0.148    3.4549      -166.75  -21.9253   \n",
       "2821  002506   协鑫集成       0.3672     0.3303    5.8918     -693.959  -71.2908   \n",
       "\n",
       "      adratio  \n",
       "0          --  \n",
       "1          --  \n",
       "2          --  \n",
       "3          --  \n",
       "4          --  \n",
       "5          --  \n",
       "6          --  \n",
       "7          --  \n",
       "8          --  \n",
       "9          --  \n",
       "10         --  \n",
       "11         --  \n",
       "12         --  \n",
       "13         --  \n",
       "14         --  \n",
       "15         --  \n",
       "16         --  \n",
       "17         --  \n",
       "18         --  \n",
       "19         --  \n",
       "20         --  \n",
       "21         --  \n",
       "22         --  \n",
       "23         --  \n",
       "24         --  \n",
       "25         --  \n",
       "26         --  \n",
       "27         --  \n",
       "28         --  \n",
       "29         --  \n",
       "...       ...  \n",
       "2792  94.5686  \n",
       "2793  95.0509  \n",
       "2794  95.3401  \n",
       "2795  95.3963  \n",
       "2796  95.5365  \n",
       "2797  96.1266  \n",
       "2798  96.1985  \n",
       "2799  96.4261  \n",
       "2800  97.3603  \n",
       "2801  97.6937  \n",
       "2802  97.8582  \n",
       "2803   98.003  \n",
       "2804   98.157  \n",
       "2805  98.1999  \n",
       "2806  98.7445  \n",
       "2807  99.0479  \n",
       "2808   99.126  \n",
       "2809  99.3109  \n",
       "2810  99.7836  \n",
       "2811  100.781  \n",
       "2812  101.878  \n",
       "2813   103.46  \n",
       "2814  103.636  \n",
       "2815  105.464  \n",
       "2816  106.888  \n",
       "2817  107.231  \n",
       "2818  109.734  \n",
       "2819  110.121  \n",
       "2820  121.925  \n",
       "2821  171.291  \n",
       "\n",
       "[2822 rows x 8 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import tushare as ts\n",
    "\n",
    "# 获取2014年第3季度的偿债能力数据\n",
    "df6 = ts.get_debtpaying_data(2014,3)\n",
    "df6"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "返回值说明：\n",
    "- currentratio：流动比率\n",
    "- quickratio：速动比率\n",
    "- cashratio：现金比率\n",
    "- icratio：利息支付倍数\n",
    "- sheqratio：股东权益比率\n",
    "- adratio：股东权益增长率"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 现金流量\n",
    "按年度、季度获取现金流量数据。"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[Getting data:]################################################"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>name</th>\n",
       "      <th>cf_sales</th>\n",
       "      <th>rateofreturn</th>\n",
       "      <th>cf_nm</th>\n",
       "      <th>cf_liabilities</th>\n",
       "      <th>cashflowratio</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>600291</td>\n",
       "      <td>西水股份</td>\n",
       "      <td>236.8900</td>\n",
       "      <td>0.4004</td>\n",
       "      <td>25.4636</td>\n",
       "      <td>0.5169</td>\n",
       "      <td>53.2248</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>600485</td>\n",
       "      <td>*ST信威</td>\n",
       "      <td>11.7365</td>\n",
       "      <td>0.1141</td>\n",
       "      <td>474.5382</td>\n",
       "      <td>0.5092</td>\n",
       "      <td>67.1843</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>600683</td>\n",
       "      <td>京投发展</td>\n",
       "      <td>10.4481</td>\n",
       "      <td>0.0816</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0879</td>\n",
       "      <td>11.3713</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>000712</td>\n",
       "      <td>锦龙股份</td>\n",
       "      <td>9.8521</td>\n",
       "      <td>0.0338</td>\n",
       "      <td>1.1299</td>\n",
       "      <td>0.0495</td>\n",
       "      <td>6.6398</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>600715</td>\n",
       "      <td>文投控股</td>\n",
       "      <td>8.7834</td>\n",
       "      <td>0.0647</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0635</td>\n",
       "      <td>18.5618</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>300059</td>\n",
       "      <td>东方财富</td>\n",
       "      <td>5.7247</td>\n",
       "      <td>0.4412</td>\n",
       "      <td>30.3246</td>\n",
       "      <td>0.7406</td>\n",
       "      <td>74.2282</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>000668</td>\n",
       "      <td>荣丰控股</td>\n",
       "      <td>4.5200</td>\n",
       "      <td>0.0221</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0392</td>\n",
       "      <td>11.6209</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>600773</td>\n",
       "      <td>西藏城投</td>\n",
       "      <td>2.6402</td>\n",
       "      <td>0.1763</td>\n",
       "      <td>56.2188</td>\n",
       "      <td>0.2015</td>\n",
       "      <td>34.8531</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>000068</td>\n",
       "      <td>华控赛格</td>\n",
       "      <td>2.2098</td>\n",
       "      <td>0.1357</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1874</td>\n",
       "      <td>18.7577</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>600215</td>\n",
       "      <td>长春经开</td>\n",
       "      <td>1.9857</td>\n",
       "      <td>0.1104</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.2359</td>\n",
       "      <td>27.3687</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>300156</td>\n",
       "      <td>神雾环保</td>\n",
       "      <td>1.6736</td>\n",
       "      <td>0.0509</td>\n",
       "      <td>13.1981</td>\n",
       "      <td>0.1571</td>\n",
       "      <td>16.1921</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>000831</td>\n",
       "      <td>五矿稀土</td>\n",
       "      <td>1.5105</td>\n",
       "      <td>0.2570</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.4717</td>\n",
       "      <td>249.6343</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>600606</td>\n",
       "      <td>绿地控股</td>\n",
       "      <td>1.2747</td>\n",
       "      <td>0.0205</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0319</td>\n",
       "      <td>4.1226</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>000526</td>\n",
       "      <td>紫光学大</td>\n",
       "      <td>1.1436</td>\n",
       "      <td>0.0672</td>\n",
       "      <td>19.1733</td>\n",
       "      <td>0.3039</td>\n",
       "      <td>30.6222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>600892</td>\n",
       "      <td>大晟文化</td>\n",
       "      <td>1.1023</td>\n",
       "      <td>0.4985</td>\n",
       "      <td>181.2775</td>\n",
       "      <td>0.5882</td>\n",
       "      <td>61.4555</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>601016</td>\n",
       "      <td>节能风电</td>\n",
       "      <td>1.0236</td>\n",
       "      <td>0.0633</td>\n",
       "      <td>7.1132</td>\n",
       "      <td>0.0881</td>\n",
       "      <td>32.2937</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>600020</td>\n",
       "      <td>中原高速</td>\n",
       "      <td>0.9504</td>\n",
       "      <td>0.0551</td>\n",
       "      <td>3.9973</td>\n",
       "      <td>0.0682</td>\n",
       "      <td>23.7676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>000609</td>\n",
       "      <td>中迪投资</td>\n",
       "      <td>0.8667</td>\n",
       "      <td>0.0144</td>\n",
       "      <td>8.4180</td>\n",
       "      <td>0.0351</td>\n",
       "      <td>3.5431</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>600025</td>\n",
       "      <td>华能水电</td>\n",
       "      <td>0.8226</td>\n",
       "      <td>0.0666</td>\n",
       "      <td>2.7258</td>\n",
       "      <td>0.0850</td>\n",
       "      <td>29.8509</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>000150</td>\n",
       "      <td>宜华健康</td>\n",
       "      <td>0.8011</td>\n",
       "      <td>0.0248</td>\n",
       "      <td>85.6560</td>\n",
       "      <td>0.0355</td>\n",
       "      <td>4.2698</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>600106</td>\n",
       "      <td>重庆路桥</td>\n",
       "      <td>0.7848</td>\n",
       "      <td>0.0323</td>\n",
       "      <td>1.0290</td>\n",
       "      <td>0.0593</td>\n",
       "      <td>133.0939</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>000603</td>\n",
       "      <td>盛达矿业</td>\n",
       "      <td>0.7845</td>\n",
       "      <td>0.3695</td>\n",
       "      <td>1.5339</td>\n",
       "      <td>1.0780</td>\n",
       "      <td>112.0816</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>002322</td>\n",
       "      <td>理工环科</td>\n",
       "      <td>0.7595</td>\n",
       "      <td>0.0689</td>\n",
       "      <td>4.7269</td>\n",
       "      <td>2.6185</td>\n",
       "      <td>261.8500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>601200</td>\n",
       "      <td>上海环境</td>\n",
       "      <td>0.7532</td>\n",
       "      <td>0.0772</td>\n",
       "      <td>2.5356</td>\n",
       "      <td>0.1611</td>\n",
       "      <td>83.8674</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>000429</td>\n",
       "      <td>粤高速A</td>\n",
       "      <td>0.7297</td>\n",
       "      <td>0.0644</td>\n",
       "      <td>2.2566</td>\n",
       "      <td>0.1157</td>\n",
       "      <td>69.3146</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>000722</td>\n",
       "      <td>湖南发展</td>\n",
       "      <td>0.7287</td>\n",
       "      <td>0.0551</td>\n",
       "      <td>1.0461</td>\n",
       "      <td>0.2965</td>\n",
       "      <td>78.1368</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>601188</td>\n",
       "      <td>龙江交通</td>\n",
       "      <td>0.7147</td>\n",
       "      <td>0.0602</td>\n",
       "      <td>0.8511</td>\n",
       "      <td>0.3004</td>\n",
       "      <td>31.8420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>600033</td>\n",
       "      <td>福建高速</td>\n",
       "      <td>0.7049</td>\n",
       "      <td>0.0741</td>\n",
       "      <td>2.1425</td>\n",
       "      <td>0.1481</td>\n",
       "      <td>54.3564</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>002622</td>\n",
       "      <td>融钰集团</td>\n",
       "      <td>0.6857</td>\n",
       "      <td>0.0532</td>\n",
       "      <td>2.6115</td>\n",
       "      <td>0.8161</td>\n",
       "      <td>84.5952</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>601199</td>\n",
       "      <td>江南水务</td>\n",
       "      <td>0.6754</td>\n",
       "      <td>0.0933</td>\n",
       "      <td>2.6183</td>\n",
       "      <td>0.2225</td>\n",
       "      <td>24.7427</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2792</th>\n",
       "      <td>601198</td>\n",
       "      <td>东兴证券</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1166</td>\n",
       "      <td>5.7762</td>\n",
       "      <td>0.1451</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2793</th>\n",
       "      <td>603636</td>\n",
       "      <td>南威软件</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0616</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1748</td>\n",
       "      <td>17.5110</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2794</th>\n",
       "      <td>002736</td>\n",
       "      <td>国信证券</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0183</td>\n",
       "      <td>0.7197</td>\n",
       "      <td>0.0231</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2795</th>\n",
       "      <td>600369</td>\n",
       "      <td>西南证券</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0831</td>\n",
       "      <td>3.7608</td>\n",
       "      <td>0.1413</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2796</th>\n",
       "      <td>000166</td>\n",
       "      <td>申万宏源</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.1974</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2797</th>\n",
       "      <td>600999</td>\n",
       "      <td>招商证券</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0565</td>\n",
       "      <td>2.9284</td>\n",
       "      <td>0.0815</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2798</th>\n",
       "      <td>601108</td>\n",
       "      <td>财通证券</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1176</td>\n",
       "      <td>6.8540</td>\n",
       "      <td>0.1430</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2799</th>\n",
       "      <td>600036</td>\n",
       "      <td>招商银行</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0320</td>\n",
       "      <td>3.2921</td>\n",
       "      <td>0.0342</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2800</th>\n",
       "      <td>601398</td>\n",
       "      <td>工商银行</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0038</td>\n",
       "      <td>0.3472</td>\n",
       "      <td>0.0041</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2801</th>\n",
       "      <td>601939</td>\n",
       "      <td>建设银行</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0277</td>\n",
       "      <td>2.4329</td>\n",
       "      <td>0.0299</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2802</th>\n",
       "      <td>300364</td>\n",
       "      <td>中文在线</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.0770</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.2646</td>\n",
       "      <td>-27.0377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2803</th>\n",
       "      <td>300445</td>\n",
       "      <td>康斯特</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2804</th>\n",
       "      <td>600000</td>\n",
       "      <td>浦发银行</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0127</td>\n",
       "      <td>1.4237</td>\n",
       "      <td>0.0135</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2805</th>\n",
       "      <td>601328</td>\n",
       "      <td>交通银行</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.0012</td>\n",
       "      <td>-0.1402</td>\n",
       "      <td>-0.0013</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2806</th>\n",
       "      <td>601377</td>\n",
       "      <td>兴业证券</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.0393</td>\n",
       "      <td>-1.7986</td>\n",
       "      <td>-0.0532</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2807</th>\n",
       "      <td>601601</td>\n",
       "      <td>中国太保</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0368</td>\n",
       "      <td>3.3655</td>\n",
       "      <td>0.0426</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2808</th>\n",
       "      <td>601788</td>\n",
       "      <td>光大证券</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0545</td>\n",
       "      <td>4.9232</td>\n",
       "      <td>0.0775</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2809</th>\n",
       "      <td>000728</td>\n",
       "      <td>国元证券</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0715</td>\n",
       "      <td>3.0053</td>\n",
       "      <td>0.1234</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2810</th>\n",
       "      <td>600837</td>\n",
       "      <td>海通证券</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0091</td>\n",
       "      <td>0.4273</td>\n",
       "      <td>0.0127</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2811</th>\n",
       "      <td>601288</td>\n",
       "      <td>农业银行</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0041</td>\n",
       "      <td>0.4301</td>\n",
       "      <td>0.0044</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2812</th>\n",
       "      <td>603698</td>\n",
       "      <td>航天工程</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1038</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1643</td>\n",
       "      <td>17.2161</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2813</th>\n",
       "      <td>600958</td>\n",
       "      <td>东方证券</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.0472</td>\n",
       "      <td>-2.9327</td>\n",
       "      <td>-0.0584</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2814</th>\n",
       "      <td>600016</td>\n",
       "      <td>民生银行</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0237</td>\n",
       "      <td>2.3912</td>\n",
       "      <td>0.0254</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2815</th>\n",
       "      <td>601211</td>\n",
       "      <td>国泰君安</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.6189</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2816</th>\n",
       "      <td>601336</td>\n",
       "      <td>新华保险</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0492</td>\n",
       "      <td>4.7483</td>\n",
       "      <td>0.0533</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2817</th>\n",
       "      <td>601988</td>\n",
       "      <td>中国银行</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0269</td>\n",
       "      <td>3.0313</td>\n",
       "      <td>0.0288</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2818</th>\n",
       "      <td>000750</td>\n",
       "      <td>国海证券</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1306</td>\n",
       "      <td>6.6008</td>\n",
       "      <td>0.1824</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2819</th>\n",
       "      <td>002673</td>\n",
       "      <td>西部证券</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1536</td>\n",
       "      <td>7.4871</td>\n",
       "      <td>0.2039</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2820</th>\n",
       "      <td>000750</td>\n",
       "      <td>国海证券</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1306</td>\n",
       "      <td>6.6008</td>\n",
       "      <td>0.1824</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2821</th>\n",
       "      <td>002673</td>\n",
       "      <td>西部证券</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1536</td>\n",
       "      <td>7.4871</td>\n",
       "      <td>0.2039</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2822 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        code   name  cf_sales  rateofreturn     cf_nm  cf_liabilities  \\\n",
       "0     600291   西水股份  236.8900        0.4004   25.4636          0.5169   \n",
       "1     600485  *ST信威   11.7365        0.1141  474.5382          0.5092   \n",
       "2     600683   京投发展   10.4481        0.0816       NaN          0.0879   \n",
       "3     000712   锦龙股份    9.8521        0.0338    1.1299          0.0495   \n",
       "4     600715   文投控股    8.7834        0.0647       NaN          0.0635   \n",
       "5     300059   东方财富    5.7247        0.4412   30.3246          0.7406   \n",
       "6     000668   荣丰控股    4.5200        0.0221       NaN          0.0392   \n",
       "7     600773   西藏城投    2.6402        0.1763   56.2188          0.2015   \n",
       "8     000068   华控赛格    2.2098        0.1357       NaN          0.1874   \n",
       "9     600215   长春经开    1.9857        0.1104       NaN          0.2359   \n",
       "10    300156   神雾环保    1.6736        0.0509   13.1981          0.1571   \n",
       "11    000831   五矿稀土    1.5105        0.2570       NaN          2.4717   \n",
       "12    600606   绿地控股    1.2747        0.0205       NaN          0.0319   \n",
       "13    000526   紫光学大    1.1436        0.0672   19.1733          0.3039   \n",
       "14    600892   大晟文化    1.1023        0.4985  181.2775          0.5882   \n",
       "15    601016   节能风电    1.0236        0.0633    7.1132          0.0881   \n",
       "16    600020   中原高速    0.9504        0.0551    3.9973          0.0682   \n",
       "17    000609   中迪投资    0.8667        0.0144    8.4180          0.0351   \n",
       "18    600025   华能水电    0.8226        0.0666    2.7258          0.0850   \n",
       "19    000150   宜华健康    0.8011        0.0248   85.6560          0.0355   \n",
       "20    600106   重庆路桥    0.7848        0.0323    1.0290          0.0593   \n",
       "21    000603   盛达矿业    0.7845        0.3695    1.5339          1.0780   \n",
       "22    002322   理工环科    0.7595        0.0689    4.7269          2.6185   \n",
       "23    601200   上海环境    0.7532        0.0772    2.5356          0.1611   \n",
       "24    000429   粤高速A    0.7297        0.0644    2.2566          0.1157   \n",
       "25    000722   湖南发展    0.7287        0.0551    1.0461          0.2965   \n",
       "26    601188   龙江交通    0.7147        0.0602    0.8511          0.3004   \n",
       "27    600033   福建高速    0.7049        0.0741    2.1425          0.1481   \n",
       "28    002622   融钰集团    0.6857        0.0532    2.6115          0.8161   \n",
       "29    601199   江南水务    0.6754        0.0933    2.6183          0.2225   \n",
       "...      ...    ...       ...           ...       ...             ...   \n",
       "2792  601198   东兴证券       NaN        0.1166    5.7762          0.1451   \n",
       "2793  603636   南威软件       NaN        0.0616       NaN          0.1748   \n",
       "2794  002736   国信证券       NaN        0.0183    0.7197          0.0231   \n",
       "2795  600369   西南证券       NaN        0.0831    3.7608          0.1413   \n",
       "2796  000166   申万宏源       NaN           NaN    6.1974             NaN   \n",
       "2797  600999   招商证券       NaN        0.0565    2.9284          0.0815   \n",
       "2798  601108   财通证券       NaN        0.1176    6.8540          0.1430   \n",
       "2799  600036   招商银行       NaN        0.0320    3.2921          0.0342   \n",
       "2800  601398   工商银行       NaN        0.0038    0.3472          0.0041   \n",
       "2801  601939   建设银行       NaN        0.0277    2.4329          0.0299   \n",
       "2802  300364   中文在线       NaN       -0.0770       NaN         -0.2646   \n",
       "2803  300445    康斯特       NaN           NaN       NaN             NaN   \n",
       "2804  600000   浦发银行       NaN        0.0127    1.4237          0.0135   \n",
       "2805  601328   交通银行       NaN       -0.0012   -0.1402         -0.0013   \n",
       "2806  601377   兴业证券       NaN       -0.0393   -1.7986         -0.0532   \n",
       "2807  601601   中国太保       NaN        0.0368    3.3655          0.0426   \n",
       "2808  601788   光大证券       NaN        0.0545    4.9232          0.0775   \n",
       "2809  000728   国元证券       NaN        0.0715    3.0053          0.1234   \n",
       "2810  600837   海通证券       NaN        0.0091    0.4273          0.0127   \n",
       "2811  601288   农业银行       NaN        0.0041    0.4301          0.0044   \n",
       "2812  603698   航天工程       NaN        0.1038       NaN          0.1643   \n",
       "2813  600958   东方证券       NaN       -0.0472   -2.9327         -0.0584   \n",
       "2814  600016   民生银行       NaN        0.0237    2.3912          0.0254   \n",
       "2815  601211   国泰君安       NaN           NaN    3.6189             NaN   \n",
       "2816  601336   新华保险       NaN        0.0492    4.7483          0.0533   \n",
       "2817  601988   中国银行       NaN        0.0269    3.0313          0.0288   \n",
       "2818  000750   国海证券       NaN        0.1306    6.6008          0.1824   \n",
       "2819  002673   西部证券       NaN        0.1536    7.4871          0.2039   \n",
       "2820  000750   国海证券       NaN        0.1306    6.6008          0.1824   \n",
       "2821  002673   西部证券       NaN        0.1536    7.4871          0.2039   \n",
       "\n",
       "      cashflowratio  \n",
       "0           53.2248  \n",
       "1           67.1843  \n",
       "2           11.3713  \n",
       "3            6.6398  \n",
       "4           18.5618  \n",
       "5           74.2282  \n",
       "6           11.6209  \n",
       "7           34.8531  \n",
       "8           18.7577  \n",
       "9           27.3687  \n",
       "10          16.1921  \n",
       "11         249.6343  \n",
       "12           4.1226  \n",
       "13          30.6222  \n",
       "14          61.4555  \n",
       "15          32.2937  \n",
       "16          23.7676  \n",
       "17           3.5431  \n",
       "18          29.8509  \n",
       "19           4.2698  \n",
       "20         133.0939  \n",
       "21         112.0816  \n",
       "22         261.8500  \n",
       "23          83.8674  \n",
       "24          69.3146  \n",
       "25          78.1368  \n",
       "26          31.8420  \n",
       "27          54.3564  \n",
       "28          84.5952  \n",
       "29          24.7427  \n",
       "...             ...  \n",
       "2792            NaN  \n",
       "2793        17.5110  \n",
       "2794            NaN  \n",
       "2795            NaN  \n",
       "2796            NaN  \n",
       "2797            NaN  \n",
       "2798            NaN  \n",
       "2799            NaN  \n",
       "2800            NaN  \n",
       "2801            NaN  \n",
       "2802       -27.0377  \n",
       "2803            NaN  \n",
       "2804            NaN  \n",
       "2805            NaN  \n",
       "2806            NaN  \n",
       "2807            NaN  \n",
       "2808            NaN  \n",
       "2809            NaN  \n",
       "2810            NaN  \n",
       "2811            NaN  \n",
       "2812        17.2161  \n",
       "2813            NaN  \n",
       "2814            NaN  \n",
       "2815            NaN  \n",
       "2816            NaN  \n",
       "2817            NaN  \n",
       "2818            NaN  \n",
       "2819            NaN  \n",
       "2820            NaN  \n",
       "2821            NaN  \n",
       "\n",
       "[2822 rows x 7 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import tushare as ts\n",
    "\n",
    "# 获取2014年第3季度的偿债能力数据\n",
    "df7 = ts.get_cashflow_data(2014,3)\n",
    "df7"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "返回值说明：\n",
    "- cf_sales：经营现金净流量对销售收入比率\n",
    "- rateofreturn：资产的经营现金流量回报率\n",
    "- cf_nm：经营现金净流量与净利润的比率\n",
    "- cf_liabilities：经营现金净流量对负债比率\n",
    "- cashflowratio：现金流量比率"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": true
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
